管理员
- 积分
- 2422
- 金钱
- 870
- 贡献
- 1279
- 注册时间
- 2023-11-3
|
发表于 2024-1-26 10:07:43
|
显示全部楼层
- *****CN命令行***** [[SQL执行语句]]
- EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
- exec sp_serveroption 'LSV_GHBILL','rpc out','true'
- exec sp_serveroption 'LSV_GHBILL','rpc','true'
- exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
- exec sp_serveroption 'LSV_DKRACNT','rpc','true'
- exec sp_serveroption 'DKRCASH','rpc out','true'
- exec sp_serveroption 'DKRCASH','rpc','true'
- exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
- exec sp_serveroption 'LSV_DKRHELION','rpc','true'
- exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
- exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
- exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
- exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
- exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
- exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
- exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
- exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
- exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
- exec sp_serveroption 'LSV_DKRTEST','rpc','true'
- exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
- exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
- exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
- exec sp_serveroption 'LSV_DKRSTA','rpc','true'
- exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
- exec sp_serveroption 'DKRACCOUNT01','rpc','true'
复制代码 数据库执行下这个代码
|
|