archieving and deleting SQL 2000 table
From: A. Tolga KILINĒ (kilinc@tis.havelsan.com.tr)
Date: 10/25/02
- Next message: Ron Talmage: "Re: Security audit"
- Previous message: Ken Schaefer: "Re: SQL 2000 and NTFS"
- Next in thread: Uri Dimant: "Re: archieving and deleting SQL 2000 table"
- Reply: Uri Dimant: "Re: archieving and deleting SQL 2000 table"
- Reply: Narayana Vyas Kondreddi: "Re: archieving and deleting SQL 2000 table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "A. Tolga KILINĒ" <kilinc@tis.havelsan.com.tr> Date: Fri, 25 Oct 2002 10:15:40 +0300
Hi,
there is a strict requirement from one of my customer that some SQL tables
never deleted before they are archieved. First problem is how to achieve
archieving? Can I do backup instead??
I can set a user as backup operator, but then he can not delete the table.
If I give rights to delete it, he can do it without backing it up!!
Please suggest a solution about the requirement.
Regards,
Tolga
- Next message: Ron Talmage: "Re: Security audit"
- Previous message: Ken Schaefer: "Re: SQL 2000 and NTFS"
- Next in thread: Uri Dimant: "Re: archieving and deleting SQL 2000 table"
- Reply: Uri Dimant: "Re: archieving and deleting SQL 2000 table"
- Reply: Narayana Vyas Kondreddi: "Re: archieving and deleting SQL 2000 table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]