DBA SCRIPTS – Page 3

SQL Server management studio (SSMS) is invisible !

Today I was messing with the SQL Server root folder in program files in looking for tablediff .exe utility that

I have been asked several times to delete multiple logins in a day in my environment then initially I was

Would you ever asked to find all administrators with sysadmin access in your server then there is a very symple

This script is very useful when you have large tables and queries against those table usually runs slow then you

Track DML Changes Using after Trigger for Update, Delete and Insert rows There is out lot many options to track

I was asked to list the Primary keys in our databases then I listed using the below script. This is very

There is out too many ways to compare two tables in SQL server but I prefer to do this task