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: 1938 | Points: 40

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 


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response