SQLServerCentral - Scripts by Lowell Izaguirre

Get DDL for any SQL 2000 table

a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything. Read more...

By Lowell Izaguirre 2009/07/28 | Source: SQLServerCentral.com | Category: sql server 7

Rating:

|

Discuss |

Briefcase | 655 reads

Get DDL for any SQL 2005 table

returns CREATE TABLE script for any table. including schema name,calculated columns, indexes with INCLUDE,rules,defaults,triggers,constraints,extended properties...everything. Read more...

By Lowell Izaguirre 2013/06/19 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 903 reads

TEXT/NTEXT Find and Replace

Find And Replace any string, in the entire table with this function. Parameterized for easy use. Read more...

By Lowell Izaguirre 2009/02/26 | Source: SQLServerCentral.com | Category: string manipulation

Rating:

|

Discuss |

Briefcase | 810 reads

Default Trace Load of All 5 Files

The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed. Read more...

By Lowell Izaguirre 2009/02/25 | Source: SQLServerCentral.com | Category: sql trace

Rating:

|

Discuss |

Briefcase | 1,112 reads

Scripts by Lowell Izaguirre

Get DDL for any SQL 2000 table

Get DDL for any SQL 2005 table

TEXT/NTEXT Find and Replace

Default Trace Load of All 5 Files

Script all indexes as CREATE INDEX statements

Search All Fields in db for a Specific String

T-SQL to Export Table Structure to a script