软件简介:
! \! M, U$ v3 ^3 ~. d2 n( J第三课:SQL2000附加数据库架设外网神泣, k0 G" e' _# |1 a8 E
SQL2000+SP4补丁' r- D6 U+ F2 L G3 E" c
1 c; n+ @, b& x安装扩展存储过程
' T, K, [ ~) I6 ]9 S$ Q- vexec master..sp_addextendedproc 'xp_crypt', 'D:\ShaiyaServer\master\xp_crypt.dll', I3 t3 k' Y! C" w4 S% h
查询分析器执行
" B4 b2 m- E9 l S: g" I+ hif exists(select * f8 m, @" l- n) ]' ?' a
from master..sysservers & `: ^6 Y8 w, m" I9 i
where isremote=1 and srvname='game')
' u4 E) b4 e9 \1 ^begin2 q. G+ c8 g% o [# H
exec sp_dropserver 'game','droplogins'
+ q% I4 C& j" Z+ D$ B2 f: c' cend
3 r z( L# B; j" z. Nexec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'' X% @ L) U0 A$ e/ C8 v; O
exec sp_addlinkedsrvlogin 'game','false',null,'sa','密码'
& w1 j: _* v c2 c' C( Q! zexec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
; U$ X* T h, C8 `# ]' _, Uexec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'sa','密码'
' B! j T5 O* E& L, j$ V5 E下载地址:
|