Getting Server / Database / Connection Information via T-SQL (SQL Server)
Posted on
3,922 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 |
|---|---|---|
| SQL - Creating a Table | 127 | |
| SQL - The SELECT Statement | 215 | |
| Query data with no SQL code (6) | 22 | |
| Query data with no SQL code (11) | 58 |
One of the most common issues faced while connecting to a SQL Server instance is "Login failed for user 'username'. (Microsoft SQL Server, Error: 18456)". In addition to the Error No. SQL Server will provide an Error State no. which will be helpful…
This article discusses various scenarios that can end up in a DBCC CHECKDB process getting stuck in a Killed/Rollback state and how to resolve the problem.
Suggested Courses
Next Video:Query data with no SQL code (2)