Tag Archives: tsql

TSQL to find users and their access on a given database

TSQL to find users and their access on a given database Advertisements

Posted in Script, SQL, SQL Query, Uncategorized | Tagged , , , | Leave a comment

Find Drive size and free space using TSQL

Posted in SQL, SQL Query | Tagged , , , , | Leave a comment

TSQL – Monitor to check number of records every hour in a given table

Posted in Azure, SQL, SQL Query, Uncategorized | Tagged , , , | Leave a comment

TSQL to start a SQL job and check all running jobs

Posted in commands, Productivity, SQL, SQL Query, Uncategorized | Tagged , , , , | Leave a comment

Time Remaining for SQL task/ Percentage Compelte (Backup/ Restore)

When we take a backup or restore a database using command, we always like to track the progress. This SQL script helps you to do the same!

Posted in Script, SQL, SQL Query | Tagged , , | Leave a comment

Find and update the owner of SQL Job, Maintenance Plan

When we update Maintenance plan, ownership of the job will be changed back to plan owner (In my case it was inactive account resulting job failure). This is a known bug in SQL Server 2005 and SQL Server 2008. (Ref: … Continue reading

Posted in Productivity, Script, SQL, SQL Query | Tagged , , , , , | Leave a comment