473,324 Members | 2,178 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Encryption for stored procedure, is it possible?

Dear sir,

I am about to finish a new asp.net application, I used a lot of ms sql
stored procedure. Those stored procudure I think is the most important part
of the application.

Now I am about to distribute this application to clients. I definitely don't
like them to look at my stored procedure.

Is there a way I can protect the source code of my stored procedure? What
will you do in such a situation?

--
Kind regards

Guoqi Zheng
guoqi AT meetholland dot com
Http://www.meetholland.com

Nov 18 '05 #1
5 1462
Two options I'm aware of:

1. Use the WITH ENCRYPTION option in the Create Procedure statement.
Look up the Create Procedure statement in BOL for more.

2. This company sells a product that will apply (supposedly) a much harder
encryption: http://www.allry.com/
-GH

"Guoqi Zheng" <no@sorry.nl> wrote in message
news:eX*************@TK2MSFTNGP10.phx.gbl...
Dear sir,

I am about to finish a new asp.net application, I used a lot of ms sql
stored procedure. Those stored procudure I think is the most important part of the application.

Now I am about to distribute this application to clients. I definitely don't like them to look at my stored procedure.

Is there a way I can protect the source code of my stored procedure? What
will you do in such a situation?

--
Kind regards

Guoqi Zheng
guoqi AT meetholland dot com
Http://www.meetholland.com

Nov 18 '05 #2
The built in Encryption in SQL Server can be hacked in under 2 minutes with
a Google search.
--
Joe Fallon

"Guoqi Zheng" <no@sorry.nl> wrote in message
news:eX*************@TK2MSFTNGP10.phx.gbl...
Dear sir,

I am about to finish a new asp.net application, I used a lot of ms sql
stored procedure. Those stored procudure I think is the most important
part
of the application.

Now I am about to distribute this application to clients. I definitely
don't
like them to look at my stored procedure.

Is there a way I can protect the source code of my stored procedure? What
will you do in such a situation?

--
Kind regards

Guoqi Zheng
guoqi AT meetholland dot com
Http://www.meetholland.com

Nov 18 '05 #3
You might consider compiling the sql into your EXE instead of using a stored
procedure.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Guoqi Zheng" <no@sorry.nl> wrote in message
news:eX*************@TK2MSFTNGP10.phx.gbl...
Dear sir,

I am about to finish a new asp.net application, I used a lot of ms sql
stored procedure. Those stored procudure I think is the most important
part
of the application.

Now I am about to distribute this application to clients. I definitely
don't
like them to look at my stored procedure.

Is there a way I can protect the source code of my stored procedure? What
will you do in such a situation?

--
Kind regards

Guoqi Zheng
guoqi AT meetholland dot com
Http://www.meetholland.com

Nov 18 '05 #4
Ya, right. I can do that. but that is going to slow down the performance a
lot and make the maintenance task very difficult.

--
Kind regards

Guoqi Zheng
guoqi AT meetholland dot com
Http://www.meetholland.com

"Steve C. Orr [MVP, MCSD]" <St***@Orr.net> wrote in message
news:e9**************@TK2MSFTNGP12.phx.gbl...
You might consider compiling the sql into your EXE instead of using a stored procedure.

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://Steve.Orr.net
"Guoqi Zheng" <no@sorry.nl> wrote in message
news:eX*************@TK2MSFTNGP10.phx.gbl...
Dear sir,

I am about to finish a new asp.net application, I used a lot of ms sql
stored procedure. Those stored procudure I think is the most important
part
of the application.

Now I am about to distribute this application to clients. I definitely
don't
like them to look at my stored procedure.

Is there a way I can protect the source code of my stored procedure? What will you do in such a situation?

--
Kind regards

Guoqi Zheng
guoqi AT meetholland dot com
Http://www.meetholland.com


Nov 18 '05 #5
The SQL Server optimizer is very good at caching dynamic SQL plans
these days. The use of stored procedures for a performance benefit is
very highly overrated - at least from the perspective of compiling and
optimization. Sprocs can still save round trips to the server, but the
pre-compiliation savings are almost negligible.

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Sun, 31 Oct 2004 01:29:01 +0200, "Guoqi Zheng" <no@sorry.nl> wrote:
Ya, right. I can do that. but that is going to slow down the performance a
lot and make the maintenance task very difficult.


Nov 18 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Robin Tucker | last post by:
Is it possible to execute a stored procedure in one database, which then itself executes a stored procedure from another database? We have decide to split our data into a tree structure (DB1) and...
1
by: Raquel | last post by:
Have a question on the Stored procedure method code generated by DB2 development center for Java stored procedures. Suppose I have a requirement to return the resultset consisting of FIRSTNME,...
6
by: Terentius Neo | last post by:
Is it possible to combine (in DB2 UDB 8.1) a stored procedure and a select statement? I mean something like this: Select c.number, call procedure( c.number ) as list from table c With best...
4
by: Mullin Yu | last post by:
i have a stored procedure at sql server 2k. which will update records and select result from temp table. if i use SqlConnection class, and i do both. but, if i use OleDbConnection class, i can...
6
by: Peter Neumaier | last post by:
Hi, I am trying to select some data through a stored procedure and would like to store the result in a local access table. Is that possible? Can somebody provide an example? Thanks&regards!...
1
by: mickyang | last post by:
My MS-SQL 2000 Database have 50 more Stored Procedure . How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL Database?
0
by: jobs | last post by:
I presumed you could do this.. and so I coded it up .. but I get this error: DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'iProductCode' <asp:FormView...
2
by: acw | last post by:
On a SQL Server 2000 db I would like to setup a stored procedure that accesses couple tables and runs the extended stored procedure xp..cmdshell. The goal is to grant users with limited privileges...
2
by: varunkumarid | last post by:
Hi to all One of my collegue was created that sp's now i want to manage all those things, i dont know how to decrypt the procedure's, we lost the copy of that procedure. I am using the...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.