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

returns:
CATALOG_NAME                DESCRIPTION
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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".
Posted
Updated 3-Apr-13 8:54am
v2

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