Skip to content

Commit 71a028d

Browse files
1 parent 6717e82 commit 71a028d

1 file changed

Lines changed: 13 additions & 1 deletion

File tree

docs/relational-databases/system-tables/system-base-tables.md

Lines changed: 13 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -81,4 +81,16 @@ ms.author: sstein
8181
|**sys.sysobjvalues**|Exists in every database. Contains a row for each general value property of an entity.|
8282
|**sys.sysguidrefs**|Exists in every database. Contains a row for each GUID classified ID reference.|
8383

84-
84+
## Updating System Base Tables
85+
You can view the data in the system tables through the system catalog views. To update the metadata present in system base tables use the appropriate TSQL interface (e.g. DDL statements). Manually updating system tables is not a supported operation. SQL Server reports the following messages when you perform direct updates to system tables:
86+
87+
### when a system table is manually updated
88+
Msg 17659: Warning: System table ID <id> has been updated directly in database ID <id> and cache coherence may not have been maintained. SQL Server should be restarted.
89+
90+
### starting a database with a system table that was manually updated
91+
Msg 3859: Warning: The system catalog was updated directly in database ID 17, most recently at date_time
92+
93+
### when you execute the DBCC_CHECKDB command after a system table is manually updated
94+
Msg 3859: Warning: The system catalog was updated directly in database ID 17, most recently at date_time.
95+
96+
If you perform manual updates to system table and you encounter a problem, you might be asked to restore from a backup or copy out the data from this affected database to a new database. For more information refer to https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-8992-database-engine-error?view=sql-server-ver15#user-action

0 commit comments

Comments
 (0)