Title

Description

Applicability

Get all Column Names and Data Types    

Retrieves column names and basic data type information for one or all tables in the curent database. 

2000, 2005, 2008, 2008R2, 2012

Check if String is All Digits

An elegant implementation of a simple ISINTEGER() function. 

2000, 2005, 2008, 2008R2, 2012

Check Collation Settings

Checks for collation mismatches at the server, database and object levels.

2000, 2005, 2008, 2008R2, 2012

Get String Composition

Return a summary of the types of characters that the input string is composed of.

2000, 2005, 2008, 2008R2, 2012

Convert all Database Objects to UNICODE

Dynamically generates an extensive ordered script to change all text-based columns in a database to use UNICODE.

2000, 2005, 2008, 2008R2, 2012