Use MasterA:程序代码开启xp_dirtree的SQL语句 EXEC sp_addextendedproc xp_dirtree,@dllname ='xplog70.dll' B:判断存储扩展是否存在 Select count(*) from master.dbo.sysobjects where xtype='X' and name='xp_dirtree' 返回结果为1就OK C:恢复xp_dirtree Exec master.dbo.addextendedproc 'xp_dirtree','xplog70.dll';select count(*) from master.dbo.sysobjects where xtype='X' and name='xp_dirtree' 返回结果为1就OK D:否则上传xplog7.0.dll Exec master.dbo.addextendedproc 'xp_dirtree','C:/WinNt/System32/xplog70.dll'
EXEC sp_addextendedproc xp_dirtree,@dllname ='xplog70.dll'
B:判断存储扩展是否存在
Select count(*) from master.dbo.sysobjects where xtype='X' and name='xp_dirtree'
返回结果为1就OK
C:恢复xp_dirtree
Exec master.dbo.addextendedproc 'xp_dirtree','xplog70.dll';select count(*) from master.dbo.sysobjects where xtype='X' and name='xp_dirtree'
返回结果为1就OK
D:否则上传xplog7.0.dll
Exec master.dbo.addextendedproc 'xp_dirtree','C:/WinNt/System32/xplog70.dll'
服务器: 消息 2812,级别 16,状态 62,行 1
未能找到存储过程 'master.dbo.addextendedproc'。
服务器: 消息 2812,级别 16,状态 62,行 1
未能找到存储过程 'master.dbo.addextendedproc'。===>
这是因为某个出于安全考虑把系统扩展存储过程所有的动态连接库都删了,所以你只要重装SQL SERVER连接端就会自动生成这些文件了.