Any script to encrypt the all SPs and Views in one go

From: Rayan Yellina (ryellina_at_hotmail.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 10:48:23 -0700

Hi,
   Is there any script to encrypt all the stored procs and
views from the database, instead of Altering them
with "WITH ENCRYPTION" manually for each and every Stored
proc and view.
The situation is, until now we never encrypted any views
or stored procs for our clients, but from now onwards we
have to encrypt them. What is the fastest or proper way to
do it. We do not have access to our client databases, so
we have to mail a CD with our scripts and they can run it.
That is why I am asking that whether there is an
usual/common way of doing this. Any work-arounds or your
experiences of doing this. Thank you very much.
-Rayan

Relevant Pages

  • Re: encryption ?
    ... If it is because you think it is proprietary then shouldn't encrypt it first, then send the entire database and and use sp_attachDb? ... This entire encyption scheme seems like a big waste of time. ... What is to stop someone from using profiler to view the script as they are being executed? ...
    (microsoft.public.sqlserver.msde)
  • Re: Any script to encrypt the all SPs and Views in one go
    ... This will look through all the views in the db, I use it refresh the views ... FETCH NEXT FROM tnames_cursor INTO @tablename ... > or stored procs for our clients, ... > have to encrypt them. ...
    (microsoft.public.sqlserver.programming)
  • Re: Database encryption.
    ... > I am writing application that encrypt paradox type database with IDEA ... which is used to mark end of string. ...
    (sci.crypt)
  • Re: 2 Keys decrypts same message
    ... > I don't want to encrypt each row twice (with a admin password ... Keeping the database secret. ... lots of disk storage and high speed LAN (Local Area ...
    (sci.crypt)
  • Re: SSN encryption
    ... >> We want to encrypt social security numbers in a database. ... address and SSN are always excluded. ... exposed if there were a breakdown in the other security precautions. ...
    (sci.crypt)