Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Cannot modify maintenance plan in SQL Server 2008

  
   Database Help (Home) -> Tools RSS
Next:  SQL Server Over Named Pipes  
Author Message
Norbert Meiss

External


Since: Aug 25, 2008
Posts: 8



(Msg. 1) Posted: Tue Dec 30, 2008 8:47 pm
Post subject: Cannot modify maintenance plan in SQL Server 2008
Archived from groups: microsoft>public>sqlserver>tools (more info?)
I registered a SQL Server 2005 in SQL Server Management Studio 2008. I see
the Maintenance Plans for the 2005 Server but cannot display or modify them.
The context menu is available but selecting Modify simply does nothing. The
right pane remains empty - no message at all.
Any ideas are appreciated.
TIA, Norbert Meiss

 >> Stay informed about: Cannot modify maintenance plan in SQL Server 2008 
Back to top
Login to vote
Jeffrey Williams

External


Since: Dec 28, 2008
Posts: 5



(Msg. 2) Posted: Wed Dec 31, 2008 10:49 am
Post subject: Re: Cannot modify maintenance plan in SQL Server 2008 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
What version is the SQL Server 2005 instance that you connected to? I
believe that you will have problems editing maintenance plans on versions
less than SP2.

"Norbert Meiss" wrote in message

> I registered a SQL Server 2005 in SQL Server Management Studio 2008. I see
> the Maintenance Plans for the 2005 Server but cannot display or modify
> them.
> The context menu is available but selecting Modify simply does nothing.
> The
> right pane remains empty - no message at all.
> Any ideas are appreciated.
> TIA, Norbert Meiss

 >> Stay informed about: Cannot modify maintenance plan in SQL Server 2008 
Back to top
Login to vote
Norbert Meiss

External


Since: Aug 25, 2008
Posts: 8



(Msg. 3) Posted: Sun Jan 04, 2009 11:51 pm
Post subject: Re: Cannot modify maintenance plan in SQL Server 2008 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
SP2 is installed in this instance of SQL Server 2005.

"Jeffrey Williams" wrote:

> What version is the SQL Server 2005 instance that you connected to? I
> believe that you will have problems editing maintenance plans on versions
> less than SP2.
>
> "Norbert Meiss" wrote in message
>
> > I registered a SQL Server 2005 in SQL Server Management Studio 2008. I see
> > the Maintenance Plans for the 2005 Server but cannot display or modify
> > them.
> > The context menu is available but selecting Modify simply does nothing.
> > The
> > right pane remains empty - no message at all.
> > Any ideas are appreciated.
> > TIA, Norbert Meiss
>
 >> Stay informed about: Cannot modify maintenance plan in SQL Server 2008 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Optimization Failure in a Maintenance Plan - Hi, We are getting a failure on a Optimization Job for a DB Maintenance Plan. The event log states a 208 error with the Job Engine. The Job History is: The job failed. The Job was invoked by Schedule 88 (Schedule 1). The last step to run was step 1..

Error with simple maintenance plan - Team; I've been getting nothing but errors recently; as I've been usign maintenance plans. Here is one of the error logs. Executing the query "EXECUTE master.dbo.xp_delete_file 0,N'',N'',N'2008-03-14T00:56:18' " failed with the following err...

changing maintenance plan connections - Is there a less time consuming way to change the connections used in SQL maintenance tasks other than plodding through the GUI of the Server Management Studio (find plan, modify, then manage connections, then select, then edit, then save). I have a..

Maintenance Plan Log time stamps - I have a simple Maintenance Plan, it does the integrity check and then a Backup. The Log reads as follows: Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server 'ServerA' as 'DOMAIN\ADMINUSER' (trusted) Starting maintenance plan..

[Sql Server 2008 RCO]Where is SSMS ? -
   Database Help (Home) -> Tools All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]