just copy and run.
Changing Linked Server Passwords
How to article on changing passwords for linked servers via TSQL and SSMS.
2017-01-26
9,470 reads
mobasha,
2009-12-17 (first published: 2008-07-13)
just copy and run.
--This query will return the linked servers infromation configured in the server. SELECT a.NAME,a.product,a.provider,a.data_source,a.catalog , f.[name],b.[uses_self_credential],b.[remote_name] FROM sys.[linked_logins] AS b INNER JOIN sys.servers AS a ON a.[server_id]=b.[server_id] INNER JOIN sys.[server_principals] AS f ON b.[local_principal_id]=f.[principal_id]
How to article on changing passwords for linked servers via TSQL and SSMS.
2017-01-26
9,470 reads
Here is a step by step procedure to create a linked server to MySQL from SQL Server.
In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.
Create a linked server on the fly in this tip.
2009-10-06
3,401 reads
Retrieve data from different data sources such as Analysis Services and SQL Server relational database as one dataset, so that you can create tables, matrices of that data.