Narayana Vyas Kondreddi submitted "This article provides you with a stored procedure that searches all columns of all the tables, owned by all users, in the current database, for a specific search string."
this article is very use full. the problem that i faced here is the performance issue. i tried this with database which is having around 450 mb database size it is consuming around 2.30 mins to complete the process. think what will happen if it is having around 4 to 8 gb database... is there any alternative solution like providing indexes