By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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
Consider database hardware needs when setting up a disaster recovery site for SQL Server. Get these considerations and server failover methods.continue reading
Find options on how to deploy reports from SQL Server Reporting Services on a website.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.