Tag: administration
-
Disk space (including mounted drive) Check via SQL Server
In my previous article on Diskspace Check via SQLServer will find only physical logical drives that is attached to the system i.e the drive which you see under my computer. Ive used this script in one of my client machine and found that this script is not capable to check disk space for mounted drives.…
-
Policy Based Management – SQL Server 2008
This article discusses the new feature named Policy Based Management in SQL Server 2008. Policy Based Management is an extensive management configuration that can be used to manage servers, databases and objects. Policy Based framework provides a way to define policies that apply to servers, databases and objects. With Policy based Management framework, you can…
-
Script to Get Job Details in SQL 2005
This script will get job details for all the jobs Applies to SQL Server 2000 SQL Server 2005 SQL Server 2008
-
Enabling Remote connections via DOS or T-SQL
How to use the script 1.) Create the procedure in master db 2.) Use the command as below
-
Trigger Status
This will list out status of the trigger in a Database. This is compatible to SQL 2000 and 2005.