Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Maintenance Plan

Author  Topic 

ksr39
Posting Yak Master

193 Posts

Posted - 2012-01-31 : 10:26:25
Hi All,

I'm trying to create a maintenance plan in one of my servers. but when Im trying to create the Maintenance plan Im getting the following error.

Invalid column name 'msx_job_id'

As my server is SQL Server 2005 with SP3 Enterprise edition. How to over come this problem.

Thank you In Advance

X002548
Not Just a Number

15586 Posts

Posted - 2012-01-31 : 12:19:19
Sorry..I don't use them

http://social.msdn.microsoft.com/Forums/en/sqltools/thread/b518d227-1caa-4ca9-9176-d99898131e0f



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx


Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/


Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-31 : 12:24:46
Is SSMS patched to the same level as the server?

--
Gail Shaw
SQL Server MVP
Go to Top of Page

ksr39
Posting Yak Master

193 Posts

Posted - 2012-01-31 : 13:41:55
How to know whether my SSMS patch is same as the server
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-31 : 15:14:59
Help -> About

--
Gail Shaw
SQL Server MVP
Go to Top of Page

ksr39
Posting Yak Master

193 Posts

Posted - 2012-01-31 : 15:54:03
Hi this is what i found

Microsoft SQL Server Management Studio 9.00.1399.00
Operating System 5.2.3790
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-02-01 : 03:04:21
So the client is RTM and the server SP3. Yeah, that's likely to cause problems. You need to patch client machines as well as servers.

--
Gail Shaw
SQL Server MVP
Go to Top of Page

ksr39
Posting Yak Master

193 Posts

Posted - 2012-02-01 : 13:04:50
ok thank you
Go to Top of Page
   

- Advertisement -