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
 What is the table and column name!

Author  Topic 

Sep410
Posting Yak Master

117 Posts

Posted - 2008-06-02 : 17:48:00
Hi,
I am working on an old database in sql2000.

I only have some records which I don’t know where it is located in database. I need to find out the table name and column name for these records.

I need your help.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-06-02 : 20:05:02
I don't understand your issue. Where are the records? In a spreadsheet, in Query Analyzer, ...?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-06-03 : 00:19:00
Don't know how to help you without any details.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-06-04 : 11:41:09
Not sure if you need this
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

Madhivanan

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

- Advertisement -