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]
Asked In: Many Interviews |