Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

I am using SQL Server 2005, I have some select and update
statements in my query with WHERE clause

I want to prevent these queries from SQL injection attacks.
What are the steps and precautions to be taken for SQL
Injection attacks?
Does anybody have suggestions?


Thanks in advance,

Answer Posted / murtaza

use DML triggers which helps u to prevent any modifications.

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What methods do you follow to protect from sql injection attack?

1029


What is proper subset of candidate key?

996


What is the purpose of data source?

1038


Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

917


How to send email from database?

1013


Explain having clause?

965


How do I setup a sql server database?

1074


Explain what is lock escalation and what is its purpose?

932


What are the properties of the transactions?

1119


How to create a dynamic cursor with the dynamic option?

1045


what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1137


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1218


Why union all is faster than union?

913


Can you get second highest salary from the table?

966


which table keeps the locking information? : Sql server administration

1092