we use the database often thats why we dont schedule it hourly;

is there another option? thanks

the back up runs everyday;

is there anyway to minimize the size?

thanks

Its already in full recovery and the transaction log backup is already included in the database maintenanceplan;

thanks

good job. it did work..if you want to disable a certain job.. no need to for the sp_dropdatabase procedure; you just need to check the msdb then sysjobs table, then...

thanks jack for the advice;

is it possible to enable this service eventhough i dont have the right sp?

thanks,

Thanks jack,

i also need the activities and queries (any add, modificaion, deletion on the database) the sysadmins users executing;

This is for compliance purposes; SQL profiler is ok. it provides all the queries being used, however it may take too much resource, if its tracing all the activites even...

Thanks so much!

is there another way on auditing the logins aside from using the SQL profiler? we would like to know, the moment the sysadmin logged in and the...

yes, it already have a primary key. but still not copying; thanks

Thanks! i thought there's another way, just hope they include this feature in the next sql edition they develop 🙂

Thanks for your help! it worked! however there's a message showing everytime the user creates a table like

"you are not logged on as the databae owner or system administrator....

thanks so much! its already working 🙂

thanks!