It's possible to use encryption in SQL Server to prevent others from seeing your SPs. According to MSDN, "Using ENCRYPTION prevents the procedure from being published as part of SQL Server replication."