finding a string on - SQL Server Forums

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 Administration

finding a string on

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2013-06-19 : 09:26:45

Hi All,
I'm in need to find a string on all the objects if any object has a specific string in the entire database.

script to find out any object with has the string used "organization_seq" in the code.

Thanks in advance

Arnav
Even you learn 1%, Learn it with 100% confidence.

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-06-19 : 09:47:31

This link might work...
http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm

--
Chandu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-19 : 10:47:12

script to find out any object with has the string used "organization_seq" in the code.

sounds like this to me


select OBJECT_NAME(object_id) AS Name,definition
FROM sys.sql_modules
where definition LIKE '% organization_seq %'

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-19 : 10:59:31

http://visakhm.blogspot.in/2012/03/advantages-of-using-syssqlmodules-view.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources