Portal Home > Knowledgebase > Articles Database > Find and Replace query required
Posted by astraeuz, 06-27-2008, 02:06 AM Hello, I have a database which is infected by some script and a weird string is appended in all columns of all tables of the MSSQL Server. I've taken all measures to secure the database, but i have to clean it up atm and remove those strings from all columns one-by-one. The tables fields are like this... So, i'm need of a query which should remove that &^$^#^^ string () thanks!
Posted by Steve_Arm, 06-27-2008, 03:10 AM I think something like this might work: Try it on one row first to see if it works.
Add to Favourites Print this Article