O'Reilly logo

Microsoft® Access Projects with Microsoft SQL Server™ by Natascha Nicol, Ralf Albrecht

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

Alphabetical List

Table 25-6 contains an alphabetical list of the most important system stored procedures and short descriptions of their parameters. The SQL Server Books Online help contains detailed information and practical examples as well as complete information about the possible parameters. It also contains information about other system stored procedures not listed in Table 25-6.

Table 25-6. System Stored Procedures and Descriptions 
Procedure Name Description and Parameters
sp_addlinkedserver Defines a linked server, which allows access to object linking and embedding database (OLE DB) data sources. Furthermore, stored procedures on the linked server can be executed. Linked servers are covered in detail in Chapter 24, “External Data ...

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