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_help_log_shipping_primary_secondary(nvarchar @primary_database)MetaData:
create procedure sys.sp_help_log_shipping_primary_secondary ( @primary_database sysname ) as begin set nocount on declare @retcode int ,@primary_id uniqueidentifier -- -- security check -- exec @retcode = sys.sp_MSlogshippingsysadmincheck if (@retcode != 0 or @@error != 0) return 1 -- -- must be invoked from master db -- if (db_name() != N'master') begin raiserror(5001, 16,-1) return 1 end -- -- Primary database should exist -- select @primary_id = primary_id from msdb.dbo.log_shipping_primary_databases where primary_database = @primary_database if (@primary_id is null) begin raiserror(32010, 10, 6, @primary_database) return 0 end -- -- select -- select secondary_server ,secondary_database from msdb.dbo.log_shipping_primary_secondaries where primary_id = @primary_id -- -- all done -- return 0 end
No comments:
Post a Comment