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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Where is my data ?

Author  Topic 

Sep410
Posting Yak Master

117 Posts

Posted - 2009-06-16 : 13:05:37
Hi All,
I am working with Sage CRM at the moment. The database is SQL server 2005.
We have problem finding in which table our data is.
I add new team to our CRM but when I go to Team table, it is empty. Since I can see it on the screen in CRM software, I think I am looking to the wrong table.
How can I search whole database and find out which table is holding my data?

Thanks,


Sep

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-06-16 : 13:08:01
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Sep410
Posting Yak Master

117 Posts

Posted - 2009-06-16 : 13:18:22
Thank you for your swift reply.
It worked.


Sep
Go to Top of Page
   

- Advertisement -