Procedure Encryption - Any side effects?

serge

If I encrypt the SQL Procedures in my database will that cause any side
effects?
Will there be performance degradation?

Is it good to encrypt them or they can easily be unencrypted?

Thank you

Jul 23 '05 #1

Subscribe Post Reply

1347

Greg D. Moore $Strider$

"serge" <se****@nospam.ehmail.com> wrote in message
news:kQ*******************@weber.videotron.net...

If I encrypt the SQL Procedures in my database will that cause any side
effects?
Will there be performance degradation?

Is it good to encrypt them or they can easily be unencrypted?
They can be fairly easily encrypted.

Thank you

Jul 23 '05 #2

David Portas

AFAIK the only side-effect is that it makes people THINK their code is
hidden. The encryption is easily broken using free tools on the net so it's
a waste of time IMO.

--
David Portas
SQL Server MVP
--

Jul 23 '05 #3

Erland Sommarskog

serge (se****@nospam.ehmail.com) writes:

If I encrypt the SQL Procedures in my database will that cause any side
effects?
Will there be performance degradation?

Is it good to encrypt them or they can easily be unencrypted?

As David said, anyone who wants to break into your code can do so. The
way I view it's like putting up a fence around your house. It doesn't
really keep evil minds out, but it prevents people from strolling into
your garden by mistake.

What is essential to protect your intellectual property is to have a
strong license agreement.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

Jul 23 '05 #4

Similar topics

logical OR obfuscation

by: Mantorok Redgormor | last post by:

Can emulation of the logical OR be done in standard C to obfuscate its use? So I don't have to use if(a||b) but instead make that even more obfuscated without its use but testing the same condition

C / C++

functions with no side-effects

by: Rouben Rostamian | last post by:

Consider the following illustrative program: #include <stdio.h> double f(double x) { return x*x; } double g(double x)

C / C++

define side effects

by: Niklaus | last post by:

This is one of the posts that i got. ------------------------------ A "side effect" of an operation is something that *happens*, not something that *is produced*. Examples: In the expression...

C / C++

problem o fc# accessing stored procedure at sql server 2k

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...

C# / C Sharp

Encryption for stored procedure, is it possible?

by: Guoqi Zheng | last post by:

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...

ASP.NET

Stored Procedure vs direct execute SQL

by: JIM.H. | last post by:

Hello, Is there any difference to between SLQ string in the code and call execute query and call a stored procedure and execute the query that way concerning speed, effectiveness, reliability,...

ASP.NET

side effects?

by: Senthil | last post by:

Hi, Whenever i read a C++ book or a newsgroup posting, i come across the terms like " before the side effects completes" , "destructor with side effects" etc. What is this side effect mean in C++...

C / C++

Proposal for Lite Encryption for Login Form without SSL

by: klenwell | last post by:

Another request for comments here. I'd like to accomplish something like the scheme outlined at this page here: http://tinyurl.com/3dtcdr In a nutshell, the form uses javascript to hash...

PHP

Why does tsSource[j].Text.ToUpper() causes side effects

by: Academia | last post by:

I get the following watch message: tsSource.Text.ToUpper() This expression causes side effects and will not be evaluated string The Text is &Edit

C# / C Sharp

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing