Generates a list of Server, Database, Table , Column Names and properties  Read more...

summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.  Read more...

Query to save all index metadata  Read more...

This Script has been build to list all the tables in a database without using a cursor.   Read more...

Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.  Read more...

this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.   Read more...

i have recently had the need to search the every database on the server for a particular string. i came up with this... it has lots of room for improvement but it works  Read more...

I have made an update of this script http://www.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database  Read more...

Often during the development lifecycle columns are added to tables that become redundant or remain unused. this script removes unused (empty) columns  Read more...

use metadata to generate basic create procedure statements for insert update and select  Read more...

This script lists all foreign keys with parent and child table information  Read more...

Quick way to get all users on all Databases  Read more...