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_assemblies_rowset(nvarchar @assembly_name, nvarchar @assembly_schema
, int @assembly_id)
MetaData:
create procedure sys.sp_assemblies_rowset ( @assembly_name sysname, @assembly_schema sysname = null, @assembly_id int = null ) as select ASSEMBLY_CATALOG = db_name(), ASSEMBLY_SCHEMA = user_name(a.principal_id), ASSEMBLY_NAME = a.name, ASSEMBLY_ID = convert(int,a.assembly_id), PERMISSION_SET = convert(NVARCHAR(30), case a.permission_set when 1 then 'SAFE' when 2 then 'EXTERNAL_ACCESS' when 3 then 'UNSAFE' end), ASSEMBLY_BINARY = af.content from sys.assemblies a inner join sys.assembly_files af on ( af.assembly_id = a.assembly_id ) where a.name = @assembly_name and (@assembly_schema is null or @assembly_schema = user_name(a.principal_id)) and (@assembly_id is null or @assembly_id = a.assembly_id) order by 1, 2, 3
No comments:
Post a Comment