[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL Server 2008 - finding data source

Posted on 2013-01-25
4
Medium Priority
?
223 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 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

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…
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.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

649 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