Posted by Erland Sommarskog on 10/01/93 11:50

(mickyang@gmail.com) writes:
> My MS-SQL 2000 Database have 50 more Stored Procedure .
>
> How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL
> Database?

I assume that you have the source code in files. Use a text editor
that supports Find/Replace with regular expressions. Open all files
in the editor. The change " AS *$" to " WITH RECOMPILE AS" in all
files.

Good text editor to use is TextPad, http://www.textpad.com.

I would also recommend that you keep a backup directory, and use a
compare merge/tool that permits you easily undo false positives. An
excellent tool for this is Beyond Compare, http://www.scootersoftware.com.

If you want something more robust, you would need to write a program
that parses the file. Hardly worth it, if you only have 50+ procedures.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Cannot remove dbo rights from a user
• Prev in forum: Re: Connecting Sql Server 2005 from ASP?
• Thread view: Re: How to FAST and EASY ENCRYPTION ALL Stored Procedure in my MS-SQL Database ?

[Reply to this message]