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
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -