【问】打开软件报错，找不到存储过程
【适用版本】商云8	【模块】基本档案	【点击数】290
【知识编号】P2016051800001
【问题描述】打开软件报错如图修复加密狗报错如图     数据库已重新安装过

【答】 请备份数据库执行以下语句创建存储过程
use master
if exists(select * from sysobjects where name =’sp_addextendedproc’ )
drop procedure sp_addextendedproc
go
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
/*
**  If we’re in a transaction, disallow the addition of the
**  extended stored procedure.
*/
set implicit_transactions off
if @@trancount > 0
begin
 raiserror(15002,-1,-1,’sp_addextendedproc’)
 return (1)
end
— Disallow 0-length string & NULL
if @dllname is null or datalength(@dllname) = 0
begin
 raiserror(15311,-1,-1,@dllname)
 return (1)
end
/*
** Create the extended procedure mapping.
*/
dbcc addextendedproc( @functname, @dllname)
return (0) — sp_addextendedproc
GO