软件简介:
第三课:SQL2000附加数据库架设外网神泣
SQL2000+SP4补丁
安装扩展存储过程
exec master..sp_addextendedproc 'xp_crypt', 'D:\ShaiyaServer\master\xp_crypt.dll'
查询分析器执行
if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'sa','密码'
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'sa','密码'
下载地址:
|