Extract Information From SQL Server Catalog Views

Posted on
3,520 Points
Last Modified:
Experience Level: Beginner
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Author:Steve Wales

Suggested Videos

Title Views Activity
SQL - Creating a Table 127
SQL - Inserting Data 187
Query data with no SQL code (2) 30
Query data with no SQL code (9) 16
When running slow stored procedures from Access it may be useful to have the application do something else rather than just show the hourglass.   In this example a form flashes a message while the stored procedure executes, and then closes itself on…
This article guides you in finding the user, process and host, which produced too many transactions filling the transaction log and preventing you from shrinking it.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month