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_MSrepl_isdbowner(nvarchar @dbname)MetaData:
create procedure sys.sp_MSrepl_isdbowner @dbname sysname AS BEGIN SET NOCOUNT ON DECLARE @retcode int DECLARE @cmd nvarchar(1000) DECLARE @isdbowner int SELECT @retcode = has_dbaccess(@dbname) IF (@retcode IS NULL) OR (@retcode = 0) BEGIN -- -- Either no access or database not found -- No need to go further -- RETURN 0 END SELECT @cmd = 'USE ' + quotename(@dbname) + ' SELECT @isdbowner = is_member(''db_owner'')' EXEC sys.sp_executesql @cmd, N'@isdbowner int output', @isdbowner output RETURN isnull(@isdbowner, 0) END
No comments:
Post a Comment