encrypting stored procedures

From: Richard Douglass (RichardD_at_arisinc.com)
Date: 08/27/03 

Date: Tue, 26 Aug 2003 17:17:38 -0700

I was just informed that I must encrpyt the stored procedures for our
production database to prevent our customers from viewing and/or modifying
them. The WITH ENCRYPTION option works well but we hav 4000+ existing
procedures.

Any ideas on the easiest (yet secure) way I can lock down the code?

Thanks!
Richard

Relevant Pages

  • Re: Surpressing System tables and objects
    ... >> How do I surpress system object and stored procedures from showing when ... > viewing Tables and stored procedures. ...
    (microsoft.public.sqlserver.server)
  • Getting native database type
    ... create stored procedures for modifying the table. ... Andy ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Determining native database data type?
    ... create stored procedures for modifying the table. ... Andy ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Surpressing System tables and objects
    ... > How do I surpress system object and stored procedures from showing when ... viewing Tables and stored procedures. ...
    (microsoft.public.sqlserver.server)
  • auto format of stored procedures??
    ... i have many stored procedures, and i'm currently working on one with many ... and i'm modifying it. ... or automatically format all the levels of a stored ... i don't find much when googling! ...
    (microsoft.public.sqlserver.clients)