>

CREATE PROCEDURE ThisOneIsReallySecure
>WITH ENCRYPTION AS
>SELECT "Try to read this one, Erik!"

Ok, smartass. :-)

You can also set permissions to disallow discovery of database details via DMO.

I just wanted to point out that these details might not be as hidden as Charlie had implied.