troubleshooting Question

truncate some string value from column - sql server 2005

Avatar of davidvilson
davidvilson asked on
Oracle DatabaseMicrosoft SQL Server 2005
3 Comments1 Solution335 ViewsLast Modified:
Dear experts,
I have a database named "DB1" which has  many tables .
Our database is crashed miserably and all the column values from almost all tables have changed (hacked)... example below.

If the original column has values like below:
Chicago,
New jersey,
New york,  etc...

Some sql injection happened and the column values are added with some weird string "www.abcd.com".
So, my column values  become like this now:

Chicagowww.abcd.com,
New jerseywww.abcd.comwww.abcd.comwww.abcd.com,
New yorkwww.abcd.comwww.abcd.com,  
etc...

if you notice, for some cities the hacker string is added 2 times, and for some 3 times etc...

Now I want a stored procedure / script that will remove / truncate all these added values.. Since the string that is added is same through out the table irrespective of no of iteration, I guess the cleansing canbe done through some sql script..
 I want the script will search whole database and and delete the hackers string.


Appreciate your help.

david
ASKER CERTIFIED SOLUTION
ppinon

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros