DBA SCRIPTS – Page 2

HOW TO VERIFY IF A BACKUP FILE IS CORRUPTED?

There are times when we do a backup as a DBA, we come across problems when we restore the backup

There are times a DBA gets a request to see the user account got locked or the user is unable

There are many ways to transfer logins between instances under the same domain like 1. Scripting out logins 2. Logins

Using STUFF function in sql serevr a column values can be retrieved as single value row, values seperated by comma’s.

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