SQL Data Access

  • Thread starter Thread starter Kenneth Keeley
  • Start date Start date
K

Kenneth Keeley

Hi,
Is it safer to use an SQL Stored Procedure or to create the querry in
asp.net code? Which would run faster? and what is the best way to protect my
SQL server from hackers.

Thanks for any help.
Kenneth Keeley
 
Kenneth,

Use Stored Procedure's with the command objects in ADO.Net. You can give the sql user no rights except to execute those SP's. Running raw SQL is always a risk and runs slower cause SQL doesn't have a pre-built query plan.

-Calvin Luttrell
ProjectThunder.com
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What are the steps to fix damaged MDF files in SQL Server? 0
Setting DocType in Asp.Net 1
Insert or Save file into SQL Server Database Table with C# Examplesand VB.Net Examples 0
Invalid Column Name Sql-Error :Executing a stored procedure 1
Web Site mapping tool. 1
IIS 7 , 2008 R2 and SQL 2008 2
Need advice: Stored Proc vs SQL Code vs GUI 2
Cannot initialize the data source for linked server 3

Back
Top