I tried to do the following:
insert into sys.extended_properties(class, class_desc, major_id, minor_id, name, value)
values(1, 'OBJECT_OR_COLUMN', 1973582069,3, 'MS_Description', 'Code used by the
State for reporting purposes');
For which I got the following error:
Msg 259, Level 16, State 1, Line 1
Ad hoc updates to system catalogs are not allowed.
Dig Deeper on SQL Server Stored Procedures
Related Q&A from Eric Johnson
What needs to be installed to run SQL Server Reporting Services (SSRS)? Get the scoop on Visual Studio and SQL Server Business Intelligence ... Continue Reading
Find how to connect to a SQL Server database using Visual Basics 6.0. Continue Reading
Consider database hardware needs when setting up a disaster recovery site for SQL Server. Get these considerations and server failover methods. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.