Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-31 : 08:18:51
|
| 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." Article Link. |
|
|
abdul gani
Starting Member
3 Posts |
Posted - 2008-12-13 : 21:52:11
|
| 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 indexesshaik abdul gani |
 |
|
|
Tomji
Starting Member
19 Posts |
|
|
|
|
|
Article: How to search all columns of all tables for a keyword?