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 |
|
pencilman78
Starting Member
2 Posts |
 Posted - 2007-02-19 : 09:35:34
|
| Hi,I want to find a value which was inserted as a dummy value in our ERP system with setup. The problem now is that we cannot locate the table where the values was written to and thus cannnot remove the value.Is there a way to "find" the value accross the database specifying in which table and column the value is located?Jacques |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-02-19 : 09:43:14
|
| [url]http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
pencilman78
Starting Member
2 Posts |
Posted - 2007-02-19 : 10:50:27
|
| Worked like a bom.Thanks |
|
|
|
|
|
|
Find value in all tables accros database