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
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.