Portal Home > Knowledgebase > Articles Database > Find and Replace query required


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.



Was this answer helpful?

Add to Favourites Add to Favourites    Print this Article Print this Article

Also Read