update OPENDATASOURCE('SQLN211','Data Source=ABC;User ID=sa;Password=ABC;Integrated Security=SSPI').ServerName.dbo.EmpAtt
sa
MSDN wrote: Important Windows Authentication is much more secure than SQL Server Authentication. You should use Windows Authentication whenever possible. OPENDATASOURCE should not be used with explicit passwords in the connection string.
OPENDATASOURCE
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)