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 |
|
cparker
Starting Member
16 Posts |
 Posted - 2008-06-04 : 12:11:02
|
| How can I search the database to find out where the Exchange rates are kept? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-04 : 12:18:37
|
| HUH!! |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
cparker
Starting Member
16 Posts |
Posted - 2008-06-04 : 16:12:49
|
| Point taken I guess. I have a workflow process program that uses SQL 2000. I need to change the exchange rates used in the program but I don't know where that information would be kept in the SQL 2000 database. Is there a way to serch the entire database using the query analyzer or enterprise manager for any table or field with convert or foreign, etc? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-04 : 16:59:45
|
| If that is columnname in 1 Database then you can use:SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name = 'yoursearchcolumn' ) |
|
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2008-06-06 : 17:15:37
|
| cparker, you could try exporting your database to an excell file, then you could take it from excell to plain text.open it in notepad and search for EURO.The information near that should give you a hit as to what column table row will have the information your looking for. |
|
|
|
|
|
|
Search for Exchange rates