May 25, 2012

sp_MSreplcopyscriptfile (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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

Total Pageviews