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 table or view or sp

Actually I have very big size of databse. Also its back up is obvious that also biger size.

In case of only data loss of one table or view or sp or change then restore whole database then get back previous backup database & restore table i.e. it consuming too much time.

I want to restore only one table or view in faster way. how i can do it. plz give any suggestions

If you database was made of seperate files you could restore individual files.

To restore only a table you need a third party product such as litespeed.

I am not sure if any product can restore only schema components i.e views and sps. Standard practice is to keep the SQL scripts for Views and SPs. Do you not have these?

|||

what is litespeed & how i can get it. give the idea plz

|||

in sql server 2005 you can use Database snapshot as

a part of your backup and restore strategy.

A database snapshot is a readonly replica of your database

so in case a table is accidentally deleted, you can copy the deleted

data from the snapshot.

other use of the snapshot is for reporting purposes so this startegy will also

boost the database performance as well