After an exploit on an ASP.NET site, the client was left with a specific string of malware code sprayed across the entire database, multiple columns of multiple tables. The prepended string is consistent and doesn't change from table to table, so theoretically if I could just do a search-and-replace across the whole database, this could be cleared up in a single operation.
I could do this fairly easily in PostgreSQL or MySQL doing something like this:
mysqldump bad_db | sed 's/evilcode//g' | mysql fixed_db
But how would you do such a thing with SQLServer? I'm not certain it's quite so simple under Windows.