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 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
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
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
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
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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,...
|
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...
|
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...
|
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®ards!...
|
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?
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
|
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...
|
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...
| | |