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_MSgetdbversion()MetaData:
-- -- Name: -- sp_MSgetdbversion -- -- Description: -- Retrieves the guid restore version value and converts it to a nearly unique int. -- -- Parameters: -- See the procedure definition. -- -- Returns: -- 0 - succeeded -- 1 - failed -- -- Result: -- None -- -- Security: -- Called by dist agents (must be made public). -- SYSADMIN or DBO of db -- Requires Certificate signature for catalog access -- create procedure sys.sp_MSgetdbversion ( @current_version int output ) as begin declare @retcode int, @currentGuid uniqueidentifier -- Security Check if is_srvrolemember('sysadmin') != 1 and is_member ('db_owner') != 1 begin raiserror (21050, 16, -1) return 1 end select @currentGuid = recovery_fork_guid from sys.database_recovery_status where database_id = db_id() if @@error <> 0 return 1 select @current_version = substring(convert(binary(16), isnull(@currentGuid, 0x0)),1,6) return 0 end
No comments:
Post a Comment