Click here to Skip to main content
15,843,727 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
Sounds easy enough ...
EXECUTE sys.sp_catalogs 'server\instance'

x                   NULL
y               NULL
z               NULL
master              NULL
model               NULL
msdb                NULL
Northwind           NULL
ReportServer$instance       NULL
ReportServer$instanceTempDB NULL
tempdb              NULL
r               NULL

This is actually a more general question that boils down to "How to set (most) ANY 'NULL' system table value to, presumeably a "user" defined value, programmatically".
Updated 3-Apr-13 9:54am

1 solution

Lookup SQL's UPDATE statement:
SQL UPDATE Statement[^]
UPDATE (Transact-SQL)[^]
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900