SP encryption

  • Hi is there away to encryption all my stored procs in one operation, in other words a bulk encryption of all stored procs.

    Thanks

  • I don't know, if third-party tools can do this. However, I would script my procedures in one file, add this WITH ENCRYPRTION for every proc and run that file back against the server. I am not aware of one single command to do this (Though that doesn't mean that none exists )

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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply