Linked DB 조회
Select * FROM SYSSERVERS
Linked DB 생성
/****** 개체: LinkedServer [GRAY_TEST] 스크립트 날짜: 11/02/2009 21:36:16 ******//*
EXEC master.dbo.sp_addlinkedserver @server = N'GRAY_TEST', @srvproduct=N'.', @provider=N'OraOLEDB.Oracle', @datasrc=N'gray_test'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'use remote collation', @optvalue=N'true'
go
EXEC sp_addlinkedsrvlogin 'GRAY_TEST','false',null,'test_account','test_password'
go
행복한 고수되셔요...
woojja ))*
\\\\\\\\\\\\\\\\\\\\\\\\
Select * FROM SYSSERVERS
Linked DB 생성
/****** 개체: LinkedServer [GRAY_TEST] 스크립트 날짜: 11/02/2009 21:36:16 ******//*
EXEC master.dbo.sp_addlinkedserver @server = N'GRAY_TEST', @srvproduct=N'.', @provider=N'OraOLEDB.Oracle', @datasrc=N'gray_test'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'use remote collation', @optvalue=N'true'
go
EXEC sp_addlinkedsrvlogin 'GRAY_TEST','false',null,'test_account','test_password'
go
행복한 고수되셔요...
woojja ))*
\\\\\\\\\\\\\\\\\\\\\\\\
반응형
'DATABASE > MS SQL' 카테고리의 다른 글
[MS SQL] 날짜 조회 쿼리 (0) | 2013.04.30 |
---|---|
[MS SQL] MS SQL Server 2005를 설치하다가 이런 메시지를 받았다면.... (0) | 2010.03.19 |
[MS SQL] Vista 나 Windows2008 Server 에서 Error 1075 번 에러를 만났다면... (0) | 2010.03.19 |
[MS SQL] SQL Server 2000 성능 데이터 보기 (0) | 2009.12.15 |
[MS SQL 2005]CTE 기능을 아십니까? (0) | 2009.03.05 |