Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

SQL Server version is as follows :

Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86)
Copyright (c) Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

In SQL Server Management Studio, under the Management node, I am unable to view the "Maintenence Folder" node. I am logged in as sa, and the account does have the sysadmin server role.

How do I get access to the "Maintenance Folder"?

share|improve this question
    
Can you see Maintenance Plans in SELECT * FROM msdb.dbo.sysssispackagefolders;? –  user6426 Sep 23 '12 at 12:28
    
Do you get an error? –  Shawn Melton Sep 24 '12 at 2:39
    
Hi Shawn, I am not getting any error. Unbale to find Maintenance folder –  Vinayak Sep 25 '12 at 5:11
    
Hi Michal, Please see the following result of query : 08AA12D5-8F98-4DAB-A4FC-980B150A5DC8 00000000-0000-0000-0000-000000000000 Maintenance Plans –  Vinayak Sep 25 '12 at 6:59
    
Which version of Management Studio are you using? –  Jon Seigel Sep 25 '12 at 22:16

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.