麻烦斑竹结束帖删帖.

#2

gameohyes2010-08-25 22:26

这是我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

#3

wifayy2010-08-25 22:29

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

#4

gameohyes2010-08-25 22:30

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

#5

gameohyes2010-08-25 22:31

我找管理去...

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

#6

静夜思2010-08-25 22:36

程序代码：

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

#7

wifayy2010-08-25 22:44

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

#8

gameohyes2010-08-25 22:48

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

麻烦斑竹结束帖 删帖.