?
Solved

SQL Server 2008 - finding data source

Posted on 2013-01-25
4
Medium Priority
?
227 Views
Last Modified: 2013-02-05
Hi and thanks for any help


This may be a basic question?

I am trying to find were the data is coming from in SQL.

Say I am looking at a screen and I see the data that I need or want to find in a table.

I want to see were that data (that is on the screen) is being placed (what table), when the user inputs that data.

I know in Access you open a screen then you have the design view were you can right click, click on properties and then you are able to see the link to that field.  That way you can find the correct table.

I want to be able to do the samething in SQL?

Please help and Thanks
0
Comment
Question by:Amour22015
  • 2
4 Comments
 

Assisted Solution

by:ParrotRob2
ParrotRob2 earned 1000 total points
ID: 38819751
That would depend on what you're looking at, and probably won't be readily available through the application.  The best thing to do is to trace it at the database server.  You can filter the trace by the user or computer making the request (issuing the SQL commands).  From this, you can analyze the select, insert, update or delete being issued or the procedure being executed.
0
 
LVL 35

Accepted Solution

by:
David Todd earned 1000 total points
ID: 38823575
Hi,

Sometimes, you can have grids and tables in applications that is fairly tightly bound to datasets which are bound to tables, and yes, for those applications, somewhere in the properties, you'll be able to discover that. But that is a MS Visual Basic/MS Visual C# trick, not necessarily a SQL one. Also by definition, since a normalised table contains only one fact per row, it takes a few tables, and maybe a few more rows to store the information that is on a screen, so maybe not.

However, in SSMS, you can fairly easily drill into each table and extract the data. But again, since in a normalised database, each table has one fact per row, it can take a few tables with several rows to flesh out something like a sales order ...

Is this just out of curiosity,  or is there more to this question? Is there something specific that you are trying to solve?

HTH
  David
0
 

Author Comment

by:Amour22015
ID: 38826643
Hi,

It is out of curiosity,

I just want to find if there is a way to follow the flow of a program.

Like in Access you can go into design view right click on the screen/form and see what table it is linked to.


Thanks
0
 

Author Closing Comment

by:Amour22015
ID: 38855176
I guess there is no easy solution, Thanks for you help.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question