急!!!存储过程不能执行!
以下为存储过程:
***********************
ALTER PROCEDURE dbo.furbishDB
@TBName varchar(50),@DS varchar(100),@Uid varchar(50),@Pwd varchar(50),@DN varchar(50)
AS
declare @tempStr varchar(5000)
declare @tmp varchar(5000)
declare @sqlStr varchar(5000)
set @tmp = 'OPENDATASOURCE(''SQLOLEDB'', ''Data Source=' + @DS +';User ID='+ @Uid +';Password=' + @Pwd +''').' + @DN +'.dbo.' + @TBName
set @tempStr = 'delete from ' + @tmp
--select @tempStr
exec @tempStr
set @sqlStr = 'insert into ' + @tmp + ' select * from ' + @TBName
--select @sqlStr
exec @sqlStr
*********************
运行dbo."furbishDB" ( @TBName = hk, @DS = gzy\gzy, @Uid = sa, @Pwd = , @DN = ksy )
**************************
报错信息如下:
delete from OPENDATASOURCE('SQLOLEDB', 'Data Source=gzy\gzy;User ID=sa;Password=').ksy.dbo.hk
在 sysservers 中未能找到服务器 'delete from OPENDATASOURCE('SQLOLEDB', 'Data Source=gzy\gzy;User ID=sa;Password=')'。请执行 sp_addlinkedserver 以将服务器添加到 sysservers。
(返回 1 行)
@RETURN_VALUE = -1
完成 dbo."furbishDB" 运行。