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 |
|
ahsan19
Starting Member
7 Posts |
 Posted - 2006-11-14 : 10:43:02
|
| I have a web application that has a few hundred drop-down lists. Each dropdown list has values that represent data which is updated in the database. I need to figure out the table that the drop-down list belongs to or makes changes to. For example, on a banking website, you may have a drop-down list that lets you change the Account Status. The values for account status could be "Active", "On Hold" etc. Given such values, what is the best way to figure out where these values are stored in the backend database? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2006-11-14 : 10:50:40
|
| Consult your data dictionary. Read up on the design spec. Ask your DBA. (Maybe) run a Profiler trace to see what gets called when the page is painted.Jay White |
 |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-11-14 : 10:51:41
|
| i would say, look at the code behind for these dropdowns, and see what SQL is being run, or what Stored Procs are being fired.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
Finding Tables
blog thingie: http://weblogs.sqlteam.com/mladenp