Anyone know of a stored procedure or piece of script that will allow me to search across EVERY database and the tables within it, for a simple bit of text?
We've just migrated about 100 databases onto a server, each database has about 50-60 tables, each table has about 30-40 fields.
These database date back from last week to 2002 and we've just discovered that back in 2004 there was a SQL injection and need to remove the offended 'crap'.
Just a dead easy bit of text, but want to go through EVERYTHING to see where it is!
Any thoughts?
We've just migrated about 100 databases onto a server, each database has about 50-60 tables, each table has about 30-40 fields.
These database date back from last week to 2002 and we've just discovered that back in 2004 there was a SQL injection and need to remove the offended 'crap'.
Just a dead easy bit of text, but want to go through EVERYTHING to see where it is!
Any thoughts?