Tuesday, April 26, 2011

SQL-Server Search Entire Databases

This will display all occurrences of the text getSubcategory in all databases in SQL-Server:
 
SELECT distinct(OBJECT_NAME(id)) FROM syscomments WHERE text like '%getSubcategory%'
 
 

No comments:

Post a Comment