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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Help Me to find out the Column occurance

Author  Topic 

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2008-08-01 : 09:08:54
Hi All,

how to find out where all the particular column is used in the database.
The column may be used in SP's or Views Or Functions

How to find that.

Thanks
Ganesh Kumar

Solutions are easy. Understanding the problem, now, that's the hard part

blindman
Master Smack Fu Yak Hacker

2365 Posts

Posted - 2008-08-01 : 09:58:38
Script the code to a file and do a text search.

e4 d5 xd5 Nf6
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-01 : 23:59:49
Query information_schema.columns and syscomments.
Go to Top of Page

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2008-08-02 : 02:18:00
thanks for your reply..

Solutions are easy. Understanding the problem, now, that's the hard part
Go to Top of Page
   

- Advertisement -