SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 finding a string on
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sunsanvin
Flowing Fount of Yak Knowledge

India
1274 Posts

Posted - 06/19/2013 :  09:26:45  Show Profile  Send sunsanvin a Yahoo! Message  Reply with Quote
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
Flowing Fount of Yak Knowledge

India
2223 Posts

Posted - 06/19/2013 :  09:47:31  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 06/19/2013 :  10:47:12  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 06/19/2013 :  10:59:31  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000