EXEC master.dbo.sp_addlinkedserver
@server = N'GXBDDA-S3013', @provider = 'SQLOLEDB'
, @datasrc = N'Gxbdda-S3013', @srvproduct=''
EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname=N'Gxbdda-S3013',@useself=N'False',@locallogin=NULL
,@rmtuser='ADM_SMART',@rmtpassword='smartsmart'
exec sp_serveroption @server='Gxbdda-S3013', @optname='rpc', @optvalue='TRUE'
exec sp_serveroption @server='Gxbdda-S3013', @optname='rpc out', @optvalue='TRUE'
No comments:
Post a Comment