Complete and utter SQL noob. We have an application that talks to MSSQL, and I'm trying to add a read-only user so someone can run a separate program that talks to the database. I figured out how ...

I'm trying to create a symmetric key in SQL Server 2005 and restrict it to just the sa and application user accounts.