Solved

SQL Server 2008 - finding data source

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

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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 …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
This video discusses moving either the default database or any database to a new volume.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

708 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now