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.xp_grantlogin(nvarchar @loginame, varchar @logintype)
MetaData:
create procedure sys.xp_grantlogin @loginame sysname, @logintype varchar(5) = Null -- ignored unless 'admin' AS set nocount on -- IF NAME NOT 'DOMAIN\USER', ADD DEFAULT DOMAIN -- if (charindex('\', @loginame) = 0) begin select @loginame = default_domain() + '\' + @loginame end Declare @ret int -- return value of sp call execute @ret = sys.sp_grantlogin @loginame if (@ret = 0 and @logintype = 'admin') execute @ret = sys.sp_addsrvrolemember @loginame, 'sysadmin' return (@ret)
No comments:
Post a Comment