操作的时候失误删除了sp_dropextendedproc 过程 现在恢复不了 用addextendedproc 也不行

网上只找到了addextendedproc的恢复方法
create procedure sp_addextendedproc --- 1996/08/30 20:13
@functname nvarchar(517),/* (owner.)name of function to call */ @dllname varchar(255)/* name of DLL containing function */ as
set implicit_transactions off
if @@trancount > 0
begin
raiserror(15002,-1,-1,'sp_addextendedproc')
return (1)
end
dbcc addextendedproc( @functname, @dllname)
return (0) -- sp_addextendedproc
GO

[ 本帖最后由 wifayy 于 2010-8-26 20:38 编辑 ]

这是我sqlserver上的. sql是05的.

---------------------------- sp_dropextendedproc ------------------------------ 
create procedure sys.sp_dropextendedproc 
@functname nvarchar(517)  -- name of function 
as 
-- If we're in a transaction, disallow the dropping of the 
--  extended stored procedure. 
set implicit_transactions off 
if @@trancount > 0 
begin 
  raiserror(15002,-1,-1,'sys.sp_dropextendedproc') 
  return (1) 
end 

 
-- Drop the extended procedure mapping. 
dbcc dropextendedproc( @functname ) 
return (0) -- sp_dropextendedproc   

好多 color=#800000 这个是论坛问题吧。  麻烦斑竹整理下哦

---------------------------- sp_dropextendedproc ------------------------------  
create procedure sys.sp_dropextendedproc  
 @functname nvarchar(517)  -- name of function  
as  
 -- If we're in a transaction, disallow the dropping of the  
 --  extended stored procedure.  
 set implicit_transactions off  
 if @@trancount > 0  
 begin  
  raiserror(15002,-1,-1,'sys.sp_dropextendedproc')  
  return (1)  
 end  
  
 -- Drop the extended procedure mapping.  
 dbcc dropextendedproc( @functname )  
 return (0) -- sp_dropextendedproc

我找管理去...

[ 本帖最后由 gameohyes 于 2010-8-25 22:33 编辑 ]

---------------------------- sp_dropextendedproc ------------------------------ 
create procedure sys.sp_dropextendedproc 
@functname nvarchar(517)  -- name of function 
as 
-- If we're in a transaction, disallow the dropping of the 
--  extended stored procedure. 
set implicit_transactions off 
if @@trancount > 0 
begin 
  raiserror(15002,-1,-1,'sys.sp_dropextendedproc') 
  return (1) 
end 

 
-- Drop the extended procedure mapping. 
dbcc dropextendedproc( @functname ) 
return (0) -- sp_dropextendedproc 

6L的 也这个问题 多谢斑竹了

6L可是管理员哦.来的速度真快.赞个