2910数据库 SN代码

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

EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'/ M* b* J k7 b$ R! U
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'! |0 ?7 C" c- y
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'1 r5 o4 M1 o: T) u/ g$ p& @$ V
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
3 [! T4 {) `- C. h7 v9 o$ z
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;' f6 G7 R9 Y% I
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'. R) z$ F/ E4 q6 r9 Z
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'0 X0 p4 V! M% j4 e# Z8 i" V
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
) v# w- b% t5 \, Z0 q
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
N; q$ y* |4 V( q8 `6 S
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;' N- c9 ^: w/ e& p' L
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
* g. Q# _4 G7 r2 D9 E$ k! u% P
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'$ R7 ?+ n" |5 H6 y# |. o
) F5 g# j9 L! N" w
exec sp_serveroption 'LSV_GHBILL','rpc out','true'
& J: ^; a7 q2 Z: z2 D5 m& q4 U) w
exec sp_serveroption 'LSV_GHBILL','rpc','true' D# x7 z: w6 m- h* r
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
n7 S1 k3 w0 e/ v0 ^
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
9 D, _9 L4 P% _& N K
exec sp_serveroption 'DKRCASH','rpc out','true' 4 u) x: m4 N2 a2 G
exec sp_serveroption 'DKRCASH','rpc','true' 6 N. e) }1 N/ P- e+ O3 N' R( E
exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
6 {6 m; v5 S; r
exec sp_serveroption 'LSV_DKRHELION','rpc','true' ' H- Z; c7 }- V- k
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true' 4 {0 y. }0 D; f3 W& C
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true' 3 Y( t: S: m7 [2 o" e4 S
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true' , ~" j2 p$ `, i3 W
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
0 C. h7 E* `8 Z, p) o9 D1 v. I2 o2 {
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true' - m. K* C. F$ W) x% [
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
$ S8 A/ O. \2 c) ^( T! u$ J
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
w/ J+ @+ v4 `1 v. L$ Q5 r% H
exec sp_serveroption 'LSV_DKRSIZ','rpc','true' 0 d( r# s( y( ~
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
% S/ f' B9 }/ M) I. H5 i$ n; S
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
7 Q- q7 T# q7 k0 x
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true' / r: }* k# q' x; k4 v
exec sp_serveroption 'LSV_DKRZUTO','rpc','true' # x6 v- w$ _8 h: h
exec sp_serveroption 'LSV_DKRSTA','rpc out','true' 6 U3 j, F8 D# N: m8 S0 D
exec sp_serveroption 'LSV_DKRSTA','rpc','true'
4 s" y0 @1 m0 U6 v) R9 r
exec sp_serveroption 'DKRACCOUNT01','rpc out','true' 7 f) S$ S! `' Y# A8 [5 s
exec sp_serveroption 'DKRACCOUNT01','rpc','true'

复制代码

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

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

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

我是来学习的！

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

我是来学习的

kyile · 发表于 2024-10-2 00:25:32

666666666666666666666666

cao121 · 发表于 2024-10-13 04:44:07

技术贴，学习

大张 · 发表于 2024-10-20 13:01:11

来看看学习一下 ~！

hades8013 · 发表于 2024-11-8 22:09:47

这是啥？要执行呢

fdfdsf · 发表于 2024-11-10 19:28:55

感谢楼主分享！

klz12 · 发表于 2024-12-13 08:48:53

谢谢分享

thekingliu · 发表于 2025-3-3 17:19:23

感谢分享

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

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

相关帖子