Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Luiz Barros

SQLServerCentral.com profile

   Items 1 to 3 of 3   
 

Find and Replace a String in the Whole Database

Find and Replace a string in all string fields (char, varchar, etc) of all tables in the database.  Read more...
By Luiz Barros 2011/10/27 | Source: SQLServerCentral.com | Category: string manipulation
Rating: |  Discuss |   Briefcase | 3,273 reads

Testing all procs before upgrading to Compatibility Level 90

You can use this script to check if any procs will break under compatibility level 90.  Read more...
By Luiz Barros 2012/03/08 | Source: SQLServerCentral.com | Category: compatibility
Rating: |  Discuss |   Briefcase | 3,831 reads

Change column type on constrained columns

Use this proc if you need to alter a column that is part of a primery key  Read more...
By Luiz Barros 2008/02/04 | Source: SQLServerCentral.com | Category: referential integrity
Rating: |  Discuss |   Briefcase | 1,075 reads
   Items 1 to 3 of 3