Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Find Data Source For a Table with Imported Data

Author  Topic 

angtez
Starting Member

4 Posts

Posted - 2010-08-31 : 10:00:08
Hi All,

I hope I'm posting this question in the right place. We have an application that uses SQL Server 2005 to store our data. Some of the tables in our database are attached to the application, and some of the tables contain data imported from other sources. Is it possible to display where the data is coming from (the path) for a given table in the database?

I used sp_help, but I couldn't find what I was looking for. Any help would be greatly appreciated. Thanks in advance.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-08-31 : 10:23:56
This is what you need
http://beyondrelational.com/blogs/madhivanan/archive/2010/07/28/app-name-function.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -