Sorry ! I've just found the answer. For those that don't know and are curious ...DROP DATABASE permissions default to the database owner, members of the sysadmin and dbcreator...

Hi Cabby,

you can't restrict access to an sa user or a member of the Sysadmin role. I see where you're coming from but if you remove people from the...

Thanks folks.

There is no really need to know when the record went to archive. Once the record reaches its archive status that is generally the last business transaction. ...

Thanks Paul,

I'll take a look at that.

David

Hi Paul,

thanks for that. How would the syntax read of the transfer part.... I'm really not very confident with t-sql yet.

We don't currently use a time stamp as once the...

Hi Amit,

sa is a member of the SYSADMIN role and this can't be changed. Can you clarify a bit more what you're trying to do. You see, the "owner"...

Aha P. that might be a quirk worth checking!

Hi ,

Haven't check the enabled box yet as I have been starting the job manually to test. I'm the owner.

How do you mean Andy "whatever account is assigned to...

7.0/NT

Simply created a job CmdExec and put the full path to the .exe in the box where the T-Sql normally goes

I remember how I did it before. I'm going to pass on the whole EM vs QA discussion. If EM does it that's good enough for now....

Grazie Franco

EM has always worked for me. If I really need to use QA I will but when showing other users how to do this EM is ideal.

Regards,

DeltaKilo

Yup. Sorry for not getting back. I found both of those after some more searching.

Thanks a million

Yeah, I've got them on a production cluster server without any problems.

Thanks Steve, I found it, DBCREATOR. None of the books I have states explicitly that dbcreator can drop databases. I found it in BOL after soom searching.

David

Hi Paul,

Bingo. I will have to do some more editing to get schedules but it's a good start. Thanks

David Kelly