Getting Server / Database / Connection Information via T-SQL (SQL Server)

Posted on
3,922 Points
2 Endorsements
Last Modified:
Experience Level: Beginner
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Author:Steve Wales
1 Comment
LVL 69


by:Jim Horn
Nice job.  Voted Yes.

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.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month