I am using SQL Server 2008 Enterprise on Windows Server 2003 Enterprise. I developed some stored procedures for SQL Server and the machine installed with SQL Server may not be fully under my control (may be used by un-trusted 3rd party).
I want to protect my stored procedures T-SQL source code (i.e. not viewable by some other party) by using encrypt stored procedure function provided by SQL Server. I am not sure whether encrypt stored procedure is safe and whether the administrator of the machine (installed with SQL Server) will have ways to view stored procedure's source code?