软件简介：% L% K' T. C- x B: A5 K: V
第三课:SQL2000附加数据库架设外网神泣
# }, F- s7 {7 G9 sSQL2000+SP4补丁6 {- E) W. @1 [& c, a4 V
; N# C4 B a9 h; n7 R
安装扩展存储过程3 X2 X' W" v9 P
exec master..sp_addextendedproc 'xp_crypt', 'D:\ShaiyaServer\master\xp_crypt.dll'( z& a9 j- m% f e: ]; r
查询分析器执行; i/ t" Y& r5 x, D7 {
if exists(select * : ^+ ^; o) h+ S( Z( a+ w% v7 k
from master..sysservers ; W* W. F$ D# ]
where isremote=1 and srvname='game')
% c# {' K# j8 f$ @1 Abegin# T% Q, K9 O# |+ p' a/ h
exec sp_dropserver 'game','droplogins'
* q+ N2 B5 q: }. d# w1 Gend k1 T3 b3 K, ?, G( X$ o
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'( Z; o/ v/ B- {: L! M! d
exec sp_addlinkedsrvlogin 'game','false',null,'sa','密码'' j9 b% O) X/ a6 [1 v2 e0 C- g" ~
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'" ]+ m/ P+ E ]" r+ w- U& k
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'sa','密码'
$ U5 x$ N9 p- @: ]5 G. U# G4 G下载地址：
|
最新整理Linux手工服务端_末世策略塔防手游
