Solved

SQL Server 2008 - finding data source

Posted on 2013-01-25
4
221 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 

Assisted Solution

by:ParrotRob2
ParrotRob2 earned 250 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 250 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

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

726 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