<

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

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

Comment

by:Jim Horn
Nice job.  Voted Yes.
0
Using a combination of CROSS APPLY and VALUES one can efficiently "unpivot" data into normalised results that are far better for analysis.
This article shows how to force SQL and Web Developers to not use SA account while other services are already deployed to connect to SQL Server via SA account. So we will not touch existing services and applications only developers must be prevented.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month