Solved

SQL Server 2008 - finding data source

Posted on 2013-01-25
4
218 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 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

770 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