I need a script SQL or ASP that will do a Search and Replace in all of the tables in my Database. The Database belongs to a MCMS installation that has been infected by an SQL Injection. I have been using:
SET MyROW= REPLACE(MyROW, '<script src=http://ww.dodgyScript.us/u.js
WHERE (MyROW LIKE '%<script src=http://ww.dodgyScript.us/u.js
The above works fine but needs to by typed in once per column.
You're help is much appreciated.