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 ))*
\\\\\\\\\\\\\\\\\\\\\\\\
반응형

+ Recent posts