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

Definition:

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

MetaData:

   
create procedure sys.sp_MSdropretry (@tname sysname, @pname sysname)  
as  
    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)