MS SQL Server - Database Maintenance Planner

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Database Maintenance Planner

news.microsoft.com

2006-10-31, 12:15 am

Hi All,

What is the required user role for database maintenace plannner.

Thanks.

John Bell

2006-10-31, 7:12 pm

Hi

To invoke sp_add_maintenance_p
lan, sp_delete_maintenanc
e_plan etc... you
need to be a member of the sysadmin server role.

John

"news.microsoft.com" wrote:

> Hi All,
>
> What is the required user role for database maintenace plannner.
>
> Thanks.
>
>
>
>

Sponsored Links