how to find particular column name in DB

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)

how to find particular column name in DB

Author

Topic

hirani_prashant
Yak Posting Veteran

93 Posts

Posted - 2008-07-24 : 09:03:20

Hello All,

How to find particular column name in all store procedures, functions
for specific database?

i mean i want to find column name 'Mnemonic' in all my sp, functions for database 'tradecapture'

Can any one help me?

-- Thanks
Prashant Hirani

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-07-24 : 09:07:35

Script the SPs, functions to text file and do find

or query on syscomments

select object_name(id) as objectname from syscomments
where text like '%Mnemonic%'

Madhivanan

Failing to plan is Planning to fail

cr8nk
Yak Posting Veteran

77 Posts

Posted - 2008-07-24 : 10:49:20

-- SQL 2005
use tradecapture

go

SELECT OBJECT_NAME(OBJECT_ID)
FROM sys.sql_modules
WHERE definition LIKE '%Mnemonic%'

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-24 : 13:54:04

tradecapture is not builtin db in sql2k5.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources