SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Wes Henriksen

SQLServerCentral.com profile

   Items 1 to 5 of 5   

Get Temp Table definition

Generates a Create statement for a temp table 
By Wes Henriksen 2018/04/18 | Source: SQLServerCentral.com | Category: temporary table
Rating: |  Discuss |   Briefcase | 492 reads

Generate Create View statements for database tables.

Create views based on table definitions for backwards compatibility when relocating tables to a new database.   Read more...
By Wes Henriksen 2013/08/16 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,088 reads

Quick view of User database and server roles

Outputs an easily readable result of the database and server roles for database principals.  Read more...
By Wes Henriksen 2013/07/18 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,035 reads

Rename Foreign Key Constraints

Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion.  Read more...
By Wes Henriksen 2015/02/09 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,307 reads

Search for String in all columns

Find all columns containing a string value across all tables and schemas.  Read more...
By Wes Henriksen 2012/11/07 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,746 reads
   Items 1 to 5 of 5