Agreed... the only real options are WITH ENCRYPTION and third party tools. Your other option... although it has a host of other issues is to use CLR/.NET stored procedures which offers a lot of protection options, but moves it out of T-SQL.