Click here to Skip to main content
12,702,791 members (31,158 online)
Rate this:
Please Sign up or sign in to vote.

I have created one website and host in server, the website is work very well, I Create tables in MS SQL SERVER 2000. In tables all rows and columns data are affected by virus. so how can i remove the virus from table OR how to avoid virus affected in table. Please help me to remove the virus it's very urgent.

Virus data is : "></title><script src="
Posted 5-Oct-12 21:58pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

This is called HTML Injection (or Script injection) and the best thing to do is to ensure it doesn't happen at source. Start with Wiki: it will tell you about the subject, including ways to avoid it:[^]

You will have to clean your data yourself by looking at every text field in your database, I'm afraid!
AshishChaudha 6-Oct-12 3:17am
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

A table cannot directly host a virus.
It looks like your server has been infected by a virus - this has in turn corrupted the server.

Try running a virus scanner on your server.

As far as the data is concerned, hope you have a database backup.
prabaran 6-Oct-12 3:07am
Thanks abhinav, But i've one doubt this virus should be from our coding side mistake or server side mistake, i didn't understand how the sql tables are affected by virus.
OriginalGriff 6-Oct-12 3:10am
Not so - this is called HTML injection and in it's most primitive form consists of adding html to your user name which executes whenever anyone else sees your name on the site. Have a look at the wiki entry I sent the OP to!
Abhinav S 6-Oct-12 5:17am
Fair point.
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

please apply on dummy database or keep backup

1. you can export tables in xls and replace that string with ''
and then re-import data from xls sheet

2. use sql function to repair data, take visit of this artical,[^]

Happy Coding!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170118.1 | Last Updated 6 Oct 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100