怎么解决这个报错问题:
- SQL code
RESTORE DATABASE [LXTmp] FROM DISK = N'D:\客户资料\LX.bak' WITH FILE = 1, NOUNLOAD , STATS = 10, RECOVERY , REPLACE , MOVE N'LX_Data' TO N'd:\database\LXTmp.mdf', MOVE N'LX_Log' TO N'd:\database\LXTmp_Log.ldf'/*结果10% restored。20% restored。30% restored。40% restored。50% restored。60% restored。70% restored。80% restored。90% restored。100% restored。已处理 1152 页，这些页属于数据库 'LXTmp' 的文件 'LX_Data'（位于文件 1 上）。已处理 1 页，这些页属于数据库 'LXTmp' 的文件 'LX_Log'（位于文件 1 上）。ODBC: 消息 0，级别 16，状态 1无法装载 DLL Powerd by Nick inc. 或该 DLL 所引用的某一 DLL。原因: 126(找不到指定的模块。)。RESTORE DATABASE 操作成功地处理了 1153 页，花费了 1.907 秒（4.949 MB/秒）。*/
------解决方案--------------------
你的SQLServer是什么版本的？是不是express版？
------解决方案--------------------
use master
go
create procedure sp_dropextendedproc --- 1996/08/30 20:13
@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,'sp_dropextendedproc')
return (1)
end
go
use master;
dbcc dropextendedproc ("xp_cmdshell");
dbcc addextendedproc ("xp_cmdshell","xplog70.dll");
dbcc dropextendedproc ("xp_dirtree");
dbcc addextendedproc ("xp_dirtree","xpstar.dll");
dbcc dropextendedproc ("xp_regread");
dbcc addextendedproc ("xp_regread","xpstar.dll");
dbcc dropextendedproc ("xp_regwrite");
dbcc addextendedproc ("xp_regwrite","xpstar.dll");
dbcc dropextendedproc ("xp_regread");
dbcc addextendedproc ("xp_regread","xpstar.dll");
dbcc dropextendedproc ("xp_regdeletekey")
dbcc addextendedproc ("xp_regdeletekey","xpstar.dll")
dbcc dropextendedproc ("xp_regdeletevalue")
dbcc addextendedproc ("xp_regdeletevalue","xpstar.dll")
dbcc dropextendedproc ("sp_OACreate");
dbcc addextendedproc ("sp_OACreate","odsole70.dll");
dbcc dropextendedproc ("sp_OAMethod");
dbcc addextendedproc ("sp_OAMethod","odsole70.dll");
dbcc dropextendedproc ("xp_enumgroups");
dbcc addextendedproc ("xp_enumgroups","xplog70.dll");
dbcc dropextendedproc ("xp_fixeddrives");
godbcc addextendedproc ("xp_fixeddrives","xpstar.dll");
dbcc dropextendedproc ("xp_loginconfig");
dbcc addextendedproc ("xp_loginconfig","xplog70.dll");
dbcc dropextendedproc ("xp_enumerrorlogs");
dbcc addextendedproc ("xp_enumerrorlogs","xpstar.dll");
dbcc dropextendedproc ("xp_getfiledetails");
dbcc addextendedproc ("xp_getfiledetails","xpstar.dll");
dbcc dropextendedproc ("sp_OADestroy");
dbcc addextendedproc ("sp_OADestroy","odsole70.dll");
dbcc dropextendedproc ("sp_OAGetErrorInfo");
dbcc addextendedproc ("sp_OAGetErrorInfo","odsole70.dll");
dbcc dropextendedproc ("sp_OAGetProperty");
dbcc addextendedproc ("sp_OAGetProperty","odsole70.dll");
dbcc dropextendedproc ("sp_OASetProperty");
dbcc addextendedproc ("sp_OASetProperty","odsole70.dll");
dbcc dropextendedproc ("sp_OAStop");
godbcc addextendedproc ("sp_OAStop","odsole70.dll");