Restrict Key to SA only in SQL 2005

I have data that I want to encrypt and have the key avaiable to SA
users only. How can I revoke (or prevent) DBO from using the key? I
tried
deny view definition on symmetric key::SSKey to dbo
and got...
Cannot grant, deny, or revoke permissions to sa, dbo,
information_schema, sys, or yourself.
Any suggestions?
JimYou can have SA be the only dbo in that database or you can protect the key
with a password that is only known to SA and is the only encryption method
for the key.
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim Youmans" <jdyoumans@.gmail.com> wrote in message
news:1147976354.347670.55540@.i40g2000cwc.googlegroups.com...
>I have data that I want to encrypt and have the key avaiable to SA
> users only. How can I revoke (or prevent) DBO from using the key? I
> tried
> deny view definition on symmetric key::SSKey to dbo
> and got...
> Cannot grant, deny, or revoke permissions to sa, dbo,
> information_schema, sys, or yourself.
> Any suggestions?
> Jim
>

restoring msdb

I need some data from msdb.dbo.sysjobs and msdb.dbo.sysjobhistory but I need it from a backup file.

I don't need to restore the msdb database, I just need some data from the backup. Everytime I try to restore it under some innocuous name like bills_db it tells me msdb is in use.

Is there a way to restore this db to some other name and retrieve data from it?I never really had to do this but I imagine your sql server is getting pissed because you are trying to restore over the current msdb.

if I was you, I would create a blank database named something other than msdb and look at the WITH REPLACE argument of the RESTORE statement in books online.|||Rather that WITH REPLACE, look at WITH MOVE:

restore database msdb_copy from disk = '<disk location>' WITH
MOVE 'MSDBData' to '<different physical file name>.mdb'
,MOVE 'MSDBLog' to '<different physical file name>.ldf'
,stats