Return a list of databases which contain a table from wildcard table name.  Read more...

Size of database files for an instance of SQL Server  Read more...

Generated script to update statistics  Read more...

Generate script to reorganize indexes in a database  Read more...

Extracting data with header information using PowerShell  Read more...

We use a tally table to find the appropriate denominator for a given decimal part of a number.   Read more...

Backup all databases for an instance (complete, Differential or log of transactions)   Read more...

Count all the records from the tables that exist in a database  Read more...

Lists Tables and Store Procedure references. Runs a bit slow but appears to be accurate.  Read more...

usefull script for moving databases from one server to another  Read more...

THis script will generate the Drop and create script for all user define table type  Read more...

Generate and execute dynamically select statement for unpivot table  Read more...

Use this script to search objects in a Database. Also used to check a tables column types and details when no model is accessible. Replace <DATABASENAME> for database name.  Read more...

This script will let you get the passwords for all SQL Server principals.  Read more...

Generate script for reconstgruir ena database indexes  Read more...

Generates Scripts to move DB files from one location to another SQL and powershell scripts  Read more...

This script shows the stored procedures and functions affected by field name change in a table.  Read more...

Stored procedure to generate an insert script for a table.  Read more...

Script enables a quick creation of snapshots for databases  Read more...

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.  Read more...