Who are you trying to hide the trigger from? Assuming that you are trying to hide the trigger from the DBA you can't. Users who are members of the sysadmin fixed server role can see all the objects on the server. People who aren't sysadmin or dbo of the database can not see objects which they don't have access to.
Last Wiki Answer Submitted: December 11, 2008 3:56 am by Denny Cherry64,520 pts.