EXECUTE sys.sp_catalogs 'server\instance'
returns, once the instance has been configured for "DATA ACCESS" by doing this:
EXEC sp_serveroption 'server\instance', 'DATA ACCESS', TRUE
this:
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
And someone has suggested using UPDATE, that I could set DESCRIPTION (the ANY of the title above) to what I want the value to be.
Given that the value presently is NULL, and whatever that datatype might be that it represents, how could UPDATE be of any use? This output is tabular but it's not necessarily coming from any table; the stored procedure could be leveraging unexposed facility or other. But that's besides the point here.
How can I retain this "tabulation" nature without knowing where this system catalog data is coming from, or better yet without having to create my own tabulation, how can I alter the DESCRIPTION data itself and change NULL to ...
whatever?