Advanced Search

Return to Snippet

Revision: 67745
at October 24, 2014 03:05 by heathbo
Initial Code 
SELECT DISTINCT o.name AS Object_Name,o.type_desc
FROM sys.sql_modules m 
INNER JOIN sys.objects o 
ON m.object_id=o.object_id
WHERE m.definition Like '%YourSearchTextHere%'
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This query shows how to search all the files associated with a database for specific text.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
SQL: How To Search All Files For Specific Text

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL