How to get encrypted stored procedures?

• sliu

  Old Hand

  Points: 329

  More actions

  November 12, 2004 at 3:36 pm

  #84253

  As an SQL server database administrator, how can I get encrypted store procedures and functions. Thanks.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  November 13, 2004 at 12:54 pm

  #530028

  Not sure, if I understand you.

  If you want to know how to create an encrypted procedure, have a look at BOL at CREATE PROCEDURE. AFAIK, you can't create encrypted functions.

  But if you're after how you can decrypt an encrypted procedure, you might want to google on this. There are several freeware tools that will do this.

  --
  Frank Kalis
  Microsoft SQL Server MVP
  Webmaster: http://www.insidesql.org/blogs
  My blog: http://www.insidesql.org/blogs/frankkalis/[/url]