2910数据库 SN代码

admin · 发表于 2024-2-29 20:59:06

EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'; L! q6 h9 `/ H( K9 o
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'5 |; J( y) J# M) _
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
% `& h8 J2 h( x* Y! l; R
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
/ G0 b+ s" p8 U7 {7 D% Y3 z3 i% i
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;', u1 A$ k8 E: v' g/ }9 ?
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- y4 m0 w. A$ [: n
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'* E( o" v5 r! C9 u! J
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'5 |, K5 I8 \! g/ R% z: g! X8 C
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'/ ^; F/ H; z# c( Q) d. k. }* m
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
% Y" Z1 x+ [6 ^. b- X( v* d) |
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
8 c- F+ ]0 d: R; Z3 V, k
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'3 M. Y0 Q- U: Q7 {" }$ _1 w
, U+ p+ g( R. p( e0 I
exec sp_serveroption 'LSV_GHBILL','rpc out','true' 0 | s% c) ^ q( Y6 }: A E9 g
exec sp_serveroption 'LSV_GHBILL','rpc','true'
8 n2 r7 J: l! G- p3 t% x$ }8 P8 ~
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
& Q* p. C% m$ s5 V3 \- x
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
4 {! J: f3 y" D; @
exec sp_serveroption 'DKRCASH','rpc out','true' $ M0 J, I. V, ^+ e6 C
exec sp_serveroption 'DKRCASH','rpc','true' : A- @7 l3 P/ F( S' t4 _7 R
exec sp_serveroption 'LSV_DKRHELION','rpc out','true' 6 x& b& c2 Z" }
exec sp_serveroption 'LSV_DKRHELION','rpc','true'
: T- i G4 S" S8 A+ l4 d- m
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true' 6 i# d7 ?2 C K9 [
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
+ M& D/ S3 Q" Q8 B2 e) r+ J- B2 D
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
3 ^$ h* Q/ P. X4 j0 r
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
3 w5 R W+ R0 o2 U. @+ M0 G
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
$ P# Q' w8 b3 P# _, a0 _$ Q- J' T
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
3 P/ }0 H. w% K Q% O) u9 A: R
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true' 1 b; n' R' w6 v! F/ b
exec sp_serveroption 'LSV_DKRSIZ','rpc','true' 0 C1 H- a2 U& W. R2 V5 `1 ^
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
9 R8 P) z0 a: o. U+ z/ F8 N
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
- _$ }. V4 J+ e. E* c9 a
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true' 0 ?9 n$ m) C; Z. J: z: [
exec sp_serveroption 'LSV_DKRZUTO','rpc','true' 0 t9 p; G/ |: ~6 k6 I9 t
exec sp_serveroption 'LSV_DKRSTA','rpc out','true' 3 {$ b" d- x0 |9 l( h' C: k% e1 ~
exec sp_serveroption 'LSV_DKRSTA','rpc','true' % G. L. K3 _) w# d& I) V
exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
3 h7 h0 I9 v: q4 E
exec sp_serveroption 'DKRACCOUNT01','rpc','true'

复制代码

在数据库种执行上面语句即可

游客，如果您要查看本帖隐藏内容请回复

dxf0802 · 发表于 2024-3-1 19:10:58

我是来学习的！

hades8013 · 发表于 2024-3-11 22:53:00

我是来学习的

		自动登录	找回密码
密码			立即注册

[技术文章] 2910数据库 SN代码

本帖子中包含更多资源

相关帖子