Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.
2014-04-07 (first published: 2014-03-12)
1,703 reads
Retrieve Index Information for all tables.
2014-04-03 (first published: 2014-03-12)
1,217 reads
The script give you the list of all users and their respective Server roles
2014-04-02 (first published: 2014-03-11)
1,587 reads
This script lists all users of all databases on the server.
2014-03-31 (first published: 2014-03-03)
1,249 reads
Script to Automatically Backup, Drop and create Agent Job to restore from that backup.
2014-03-25 (first published: 2014-03-03)
1,082 reads
This script is an example of how to use Sequence, similar to Identity.
2014-03-24 (first published: 2014-02-25)
1,367 reads
Script to Check the Database Backup duration of entire instances
2014-03-19 (first published: 2014-02-25)
2,145 reads
Script to get the Database restore history details including with the files by which the database is restored.
2014-03-17 (first published: 2014-02-25)
1,318 reads
Script to get the database backup history on SQL Server 2000/2005/2008
2014-03-14 (first published: 2014-02-25)
1,548 reads
To recreate log files on sql server
2014-03-13 (first published: 2014-02-25)
1,117 reads