<

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

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

Expert Comment

by:Jim Horn
Nice job.  Voted Yes.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month