+1  A: 

This is why people have written coding standards (with defined naming conventions) and have code reviews!! Make sure you implement those procedures right now, to prevent his from getting any worse in the future.

Also for around $300, SQL Refactor™ is an excellent tool. If you were to use search and replace, you'd have countless errors and spend hours and hours editing code. I wouldn't even consider using anything other than SQL Refactor, and would never even try using a manual search and replace method on something as large as you describe.

KM  2010-05-19 12:41:03
Thanks KM, i really tried this tool during last 3 days and it give me nice results
Space Cracker  2010-05-23 06:59:57
A: 

You can use Visual Studio 2005 Database Edition, 2008 Database Edition or 2010 ultimate to load up your DB schema. This provides refactor capabilities, as well as database "builds" that check references in stored procedures, views and functions to ensure all tables and columns referenced actually exist.

ck  2010-05-19 12:45:32
i don't know this, but is it will be efficient way for my renaming case at least ?
Space Cracker  2010-05-20 08:30:34

related questions

Which, if any, C++ compilers do tail-recursion optimization?
Table Scan vs. Add Index - which is quicker?
Optimizing for low bandwidth
Getting all types that implement an interface with C# 3.5
What's optimal? UNION vs WHERE IN (str1, str2, str3)
Is there a performance difference between i++ and ++i in C++?
Is there a performance difference between i++ and ++i in C?
is it better to structure an SQL table to have a match, or return no result
SQL 2005 Book For Optimization Techniques
What's the best string concatenation method using C#?
Memory leaks in .NET
Elegant way to remove items from sequence in Python?
Most effective way for float and double comparison
Optimizing a search algorithm in C
64bit .NET Performance tuning
Speed difference in using inline strings vs concatenation in php5?
Database Case Insensitive Index?
How to overload std::swap()
Speeding up an ASP.Net Web Site or Application
Automatically measure all SQL queries
Checking for string contents? string Length Vs Empty String
Performance Considerations for throwing Exceptions
Big O, how do you calculate/approximate it?
Data verifications in Getter/Setter or elsewhere ?
Do sealed classes really offer performance Benefits?