EXEC master.dbo.sp_addlinkedserver
@server = N'DEV',
@srvproduct=N'MSDASQL',
@provider=N'SQLNCLI',
@provstr=N'DRIVER={SQL Server};SERVER=Servername\InstanceName;UID=user1;PWD=rosebud567;',
@catalog=N'database1'
@server = N'DEV',
@srvproduct=N'MSDASQL',
@provider=N'SQLNCLI',
@provstr=N'DRIVER={SQL Server};SERVER=Servername\InstanceName;UID=user1;PWD=rosebud567;',
@catalog=N'database1'
No comments:
Post a Comment