April 16, 2012

sp_catalogs_rowset (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
The meta data is from an SQL 2012 Server.

I have posted alot more, find the whole list here.

Goto Definition or MetaData

Definition:

sys.sp_catalogs_rowset(nvarchar @catalog_name)

MetaData:

   
create procedure sys.sp_catalogs_rowset
(
@catalog_name sysname
)
as
select
CATALOG_NAME = name,
DESCRIPTION = convert(nvarchar(1),null)
from
sys.databases
where
name = @catalog_name and (has_dbaccess(name)=1 OR serverproperty('EngineEdition') = 5)
order by 1

No comments:

Post a Comment

Total Pageviews