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
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.
Suggested Courses
Next Video:Query data with no SQL code (2)