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_MSreplcopyscriptfile(nvarchar @directory, nvarchar @scriptfile)
MetaData:
-- -- Name: sp_MSreplcopyscriptfile -- -- Descriptions: -- -- Parameters: as defined in create statement -- -- Returns: 0 - success -- 1 - Otherwise -- -- Security: Public procedure invoked via RPC. db_owner check -- -- Requires Certificate signature for catalog access -- CREATE PROCEDURE sys.sp_MSreplcopyscriptfile ( @directory nvarchar(4000), @scriptfile nvarchar(4000) ) as begin set nocount on declare @retcode int declare @cmd nvarchar(4000) -- -- security check -- only sysadmin can execute this -- if (isnull(is_srvrolemember('sysadmin'),0) = 0) begin raiserror(14260, 16, -1) return (1) end select @cmd = N'if not exist "' + sys.fn_escapecmdshellsymbolsremovequotes(@directory) collate database_default + '" md "' + sys.fn_escapecmdshellsymbolsremovequotes(@directory) collate database_default + '"' exec @retcode = master.dbo.xp_cmdshell @cmd, NO_OUTPUT if(@retcode <> 0) begin raiserror(21330, 16, -1, @cmd) return (1) end -- Copy script to distributor select @cmd = N'copy "' + sys.fn_escapecmdshellsymbolsremovequotes(@scriptfile) collate database_default + N'" "' + sys.fn_escapecmdshellsymbolsremovequotes(@directory) collate database_default + N'"' exec @retcode = master.dbo.xp_cmdshell @cmd, NO_OUTPUT if(@retcode <> 0) begin raiserror(21331, 16, -1, @cmd) return (1) end return (0) end
No comments:
Post a Comment