I could not see the Maintenance Plans when I login into my LoginID, But its showing in some other LoginId, Why ?

Posted by PandianS on 10/23/2010 | Category: Sql Server Interview questions | Views: 4159 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Your LoginID should be a member of SysAdmin role.

Object Explorer only displays the Maintenance Plans node for users who are members of the sysadmin fixed server role.

SELECT CASE SysAdmin WHEN 1 THEN 'You are a member of ''Sysadmin'' role' ELSE 'You are not member of ''Sysadmin'' role' END 'Sysadmin Role Permission' FROM 

(

SELECT IS_SRVROLEMEMBER(N'sysadmin') [SysAdmin]

)AS S

Asked In: Many Interviews | Alert Moderator