O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Obtaining General Information About Linked Servers

You can use both SQL Server Management Studio and the system stored procedures to gather information about linked servers and the referenced data sources. Following are some of the most-often-used system stored procedures:

Image sp_linkedservers—This returns a list of linked servers defined on the local server.

Image sp_catalogs—This displays a list of catalogs and descriptions for a specified linked server.

sp_indexes—This shows index information for a specified remote table.

sp_primarykeys—This returns ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required