일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 | 31 |
Tags
- MSSQL
- tensorflow
- scrapy
- Visual Studio Code
- 텐서플로우
- rs485
- c#
- windows10
- 파이썬
- pymssql
- django
- MSSQL PYTHON
- sql developer
- MEAN Stack
- Serial
- 자본주의
- Python
- oracle
- 티스토리 초대장
- vscode
- M2M
- MX Component
- PYTHON MSSQL
- 딥러닝
- 오라클
- matplot
- 크롤링
- rs422
- 윈도우10
- 장고
Archives
- Today
- Total
안까먹을라고 쓰는 블로그
[MSSQL] 링크드 서버 본문
반응형
---------------------------------------------------------------------------------------------------------------------------------- /****** 개체: LinkedServer [WWTMES] 스크립트 날짜: 04/19/2016 12:06:22 ******/ EXEC master.dbo.sp_addlinkedserver @server = N'TASIC', @srvproduct=N'mssql', @provider=N'SQLNCLI', @datasrc=N'192.168.12.10' /* For security reasons the linked server remote logins password is changed with ######## */ EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TASIC',@useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='ictassvr' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'collation compatible', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'data access', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'dist', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'pub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'rpc', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'rpc out', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'sub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'connect timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'collation name', @optvalue=null GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'lazy schema validation', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'query timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'TASIC', @optname=N'use remote collation', @optvalue=N'true' ---------------------------------------------------------------------------------------------------------------------------------- /****** 개체: LinkedServer [WWTMES] 스크립트 날짜: 04/19/2016 12:06:22 ******/ EXEC master.dbo.sp_addlinkedserver @server = N'TASYC', @srvproduct=N'mssql', @provider=N'SQLNCLI', @datasrc=N'192.168.180.55' /* For security reasons the linked server remote logins password is changed with ######## */ EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TASYC',@useself=N'False',@locallogin=NULL,@rmtuser=N'tasadmin',@rmtpassword='yctassvr' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'collation compatible', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'data access', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'dist', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'pub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'rpc', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'rpc out', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'sub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'connect timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'collation name', @optvalue=null GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'lazy schema validation', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'query timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'TASYC', @optname=N'use remote collation', @optvalue=N'true' ---------------------------------------------------------------------------------------------------------------------------------- /****** 개체: LinkedServer [WWTMES] 스크립트 날짜: 04/19/2016 12:06:22 ******/ EXEC master.dbo.sp_addlinkedserver @server = N'TASGS', @srvproduct=N'mssql', @provider=N'SQLNCLI', @datasrc=N'192.168.238.12' /* For security reasons the linked server remote logins password is changed with ######## */ EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'TASGS',@useself=N'False',@locallogin=NULL,@rmtuser=N'tasadmin',@rmtpassword='gstassvr' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'collation compatible', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'data access', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'dist', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'pub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'rpc', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'rpc out', @optvalue=N'true' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'sub', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'connect timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'collation name', @optvalue=null GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'lazy schema validation', @optvalue=N'false' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'query timeout', @optvalue=N'0' GO EXEC master.dbo.sp_serveroption @server=N'TASGS', @optname=N'use remote collation', @optvalue=N'true' -- 서버삭제 IF EXISTS (SELECT srv.name FROM sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'TASYC')EXEC master.dbo.sp_dropserver @server=N'TASYC', @droplogins='droplogins' -- 서버정보확인 select * from sys.servers select COUNT(*) from TASIC.TASDBIC.dbo.tblTransportation -- 44884 select COUNT(*) from TASYC.TASDBYC.dbo.tblTransportation -- 44892 select COUNT(*) from TASGS.TASDBGS.dbo.tblTransportation -- 44954 SELECT top 1 * FROM WWTMES.CJSUGAR.dbo.TB_CJ1_WTCOUNT select tpic.VehiNo as VehiNo_IC, tpic.CustomerCode as CustomerCode_IC, tpyc.VehiNo as VehiNo_YC, tpyc.CustomerCode as CustomerCode_YC from TASIC.TASDBIC.dbo.tblTransportation tpic full join TASYC.TASDBYC.dbo.tblTransportation tpyc on tpic.VehiNo = tpyc.VehiNo and tpic.CustomerCode = tpyc.CustomerCode order by tpic.VehiNo select top 10 * from TASYC.TASDBYC.dbo.tblTransportation select top 10 * from TASGS.TASDBGS.dbo.tblTransportation
반응형
'DataBase > MS SQL' 카테고리의 다른 글
[MSSQL] 별칭을 이용해서 Update (0) | 2016.05.24 |
---|---|
[MSSQL] Lock관련 (0) | 2016.05.24 |
[MSSQL] DataBase에서 프로시저, 문자, 테이블... 사용하는 부분 검색 (0) | 2014.12.02 |
[MSSQL] 간단한 성능 체크 (0) | 2014.02.14 |
[MSSQL] 프로시저안에서 프로시저 호출 (0) | 2013.11.12 |
Comments