MS SQL Server

We can use below simple script to get an information about which SSIS package is belongs to which SQL job. use msdb go select * from sysjobsteps where command like '%package name text here%' go sel...

Query to get list of articles | Pls use Independent tables instead of using whole query. SELECT DISTINCT sa.name AS articlename ,sp.publisher AS publisherserver ,sp.publisher_db AS publisherdb ,s...

 We can use below script to get complete SQL server informaiton 

How to get SQL associated mount point drive details using query Using below SQL query we can get drive details (only we can get drives which are associated to SQL server ) copy the below query to t...

How to get database complete size details We can use below script to get complete details of SQL database use master go BEGIN  SET nocount ON  IF EXISTS (SELECT 1  FROM tempdb.....