addlinkedsrv.sql

来自「管理系统源码 很好的用于参考很好对开发毕业设计很有帮助」· SQL 代码 · 共 34 行

/*创建新的*/
EXEC sp_addlinkedserver 
   'highfly_local', 
   '', 
   'SQLOLEDB',
   NULL,
   NULL,
   'DRIVER={SQL Server};SERVER=(local);'
go

EXEC sp_addlinkedsrvlogin 'highfly_local', 'false', null,'sa','samima'
go

//在master库中需加入该存储过程
create proc killspid (@dbname varchar(20)) 
as 
begin 
declare @sql nvarchar(500) 
declare @spid int 
set @sql='declare getspid cursor for 
select spid from sysprocesses where dbid=db_id(''' @dbname ''')' 
exec (@sql) 
open getspid 
fetch next from getspid into @spid 
while @@fetch_status<>-1 
begin 
exec('kill ' @spid) 
fetch next from getspid into @spid 
end 
close getspid 
deallocate getspid 
end 
GO