During migration, there was an requirement to list down all link Server with respective properties to figure out what all objects will be required in new Server. Thus a Script is required is required, which can list down all linked Servers and associated properties. The properties listed are Server Product Provider Catalog Local Login Remote [...]
SQL Server Training | Tutorials | How to's
DBATAG, a TAG to every DataBAse Consultant !!!
Join SQL Server Community
Subscribe to Email Newsletters
Recently Asked Questions- Microsoft OLE DB provider for SQL Server error 80004005
- User already exists in current database. SQL Server Error 15023
- Cannot open database requested by the login. The login failed. SQL Server Error 4060
- Cannot write property IsFileStream.This property is not available on SQL Server
- SSRS Cluster, How to Install and Configure SQL Server Reporting Service Cluster Configuration for High Availability VIDEO
- SQL AZURE pricing (PROS | CONS) – How costly is to have SQL Database on a Cloud?
- PowerShell script error – File not digitally signed : FIX
- How to upgrade SQL Server? Step by Step Guide – Screen Shots
- The query processor ran out of internal resources and could not produce a query plan. This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query. If you believe you have received this message in error, contact Customer Support Services for more information Error 8623 / 8632
- Tivoli Data Protection SQL Server – Restore Database with different name
