Browse by Tags

All Tags » forced   (RSS)
TSQL script for deleting backups older than 1 day
10 September 07 02:34 AM | SQL Master | 2 Comments   
Common question and ranting about Database maintenance plans in the forums, in this case I always suggest to use another job using TSQL to drop those older backup files. Andrew Kelly, SQL MVP has contributed an excellent script sample that should get Read More...
Retrieve SessionID and batch information
24 July 07 02:37 AM | SQL Master | 1 Comments   
You may be aware using SP_WHO or SP_WHO2 statements you can get information about a session id and statement that is running since good olden days of SQL Server. Within SQL 2005 version you can take help of TSQL: SELECT session_id, text FROM sys.dm_exec_requests Read More...