MVP Centre

Welcome to the MVP Centre. This page is the portal to a wealth of information about Microsoft Access.

SQL Server-specific

You are free to copy and use any of the samples supplied on this website for use in your own projects, provided that all copyright notices remain intact as part of the code. You may not publish the code to any website or other medium without the express written permission of the copyright holder. Each sample is provided on an "as is" basis. No warranty is expressed or implied, and no support is offered.

Information queries	Various queries for retrieving information about SQL Server objects.
Matched objects	Listing objects that appear in two SQL Server databases.
Unmatched objects	Listing objects that appear in one SQL Server database, that don't appear in another.
List all SQL Server instances	How to discover & list all instances of SQL Server in a domain.
List all SQL Server databases	How to discover & list all databases in a SQL Server instance.
List all SQL Server Stored Procedures	How to discover & list all Stored Procedures within a SQL Server database.
SQL Server objects	For functions dealing with SQL Server objects in VBA, see Databases.