How to protect SQL code in SQL Server

Question

Is it possible to protect SQL 2008 stored procedure code from anyone's eyes? Maybe some kind of encryption or assembly as a dll?

Answer 1

yes, you can save it in the database in encrypted form, but if you do, make sure that the source code is saved somewhere ...

CREATE PROCEDURE dbo.foo 
WITH ENCRYPTION 
AS 
BEGIN 
    SELECT 'foo' 
END

, . - SQL Profiler ; , , (, GO, SQL ..). , , ( CREATE PROCEDURE). snoopers, sp_password , :

CREATE PROCEDURE dbo.foo 
WITH ENCRYPTION 
AS 
BEGIN 
    SELECT 'foo' 
    -- comment: sp_password 
END

MSDN