How to Wrap Code in SQL sever

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

the wrap utility takes a readable, ASCII text file as input and converts it to a file containing byte code. The result is that the DBA, developers or anyone with database access cannot view the source code in any readable format.
The command line options for wrap are:
wrap iname=[file] oname=[file]

The Above is achievable in PL/Sql

Please refer the URL for More Details
http://www.dba-oracle.com/t_wrap_utility.htm

How to achieve it in SQL Server

Posted 25-Jul-11 20:53pm

kin karthik

Updated 25-Jul-11 21:04pm

v5

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shameel · Answer 1 · 2011-07-25T21:46:00

Solution 1

If you are talking about encrypting T-SQL code like Stored Procedures and User Defined Functions, you can use WITH ENCRYPTION option while creating them.

SQL

CREATE PROCEDURE Procedure1
(
@Param1 int
)
WITH ENCRYPTION
AS
BEGIN
    ......
END

However, note that doing this is a one way ticket and there is no way to get back the source unless you save the source to a file for your reference. Doing a generate script on the procedure will not yield the source.

Posted 25-Jul-11 21:46pm

Shameel

Comments

kin karthik 26-Jul-11 9:24am

Thanks For you Reply your reply is correct .
But DBA, developers or anyone with database access can have a facility to Decrypt the code.

I need Some Advanced technique like sql Injection or some thing.
if any ideas it would be fine

[no name] 26-Jul-11 15:12pm

No one can decrypt this (except a determined hacker).

Deepak Namdeo · Answer 2 · 2011-07-25T22:06:00

Solution 2

you can use with encrypion command

please refer below link

http://blog.sqlauthority.com/2008/11/01/sql-server-stored-procedure-with-encryption-and-execution-plan/

Posted 25-Jul-11 22:06pm

Deepak Namdeo

Comments

kin karthik 26-Jul-11 9:24am

Thanks For you Reply your reply is correct .
But DBA, developers or anyone with database access can have a facility to Decrypt the code.

I need Some Advanced technique like sql Injection or some thing.
if any ideas it would be fine

Deepak Namdeo 27-Jul-11 1:22am

karthik
no one can decrypt procedure except some paid services given exclusively.
don't bother about that,don't forget to keep copy of source code you are
encrypting.