Getting Server / Database / Connection Information via T-SQL (SQL Server)
Posted on
3,923 Points
5:18
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Videos
| Title | Views | Activity |
|---|---|---|
| Set Up Backup with Maintenance Plans (SQL Server) | 507 | |
| Query data with no SQL code (3) | 29 | |
| Query data with no SQL code (7) | 24 | |
| Query data with no SQL code (10) | 36 |
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…
An introduction article to discuss about the various Database states for troubleshooting or health check purposes. More articles will be available in this series to see how to troubleshoot each and every states described in this article.
