May 11, 2012

sp_MSdropretry (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


sys.sp_MSdropretry(nvarchar @tname
, nvarchar @pname)


create procedure sys.sp_MSdropretry (@tname sysname, @pname sysname)
declare @retcode int
declare @quotedtname nvarchar(258) -- max characters that quotename can return
declare @quotedpname nvarchar(258)

-- Check to see if current publication has permission
exec @retcode = sys.sp_MSrepl_PAL_rolecheck
if (@retcode <> 0) or (@@error <> 0)
return 1

select @quotedtname = quotename(@tname)
select @quotedpname = quotename(@pname)

exec ('drop table ' + @quotedtname)
if @@ERROR <> 0 return(1)
exec ('drop procedure ' + @quotedpname)
if @@ERROR <> 0 return(1)
return (0)

No comments:

Post a Comment

Total Pageviews