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.
| Author |
Topic |
|
derrick_goi
Starting Member
6 Posts |
 Posted - 2010-11-23 : 04:55:15
|
| after i create the maintenance plan, when i save, it appear error box "one or more arguments are invalid", kindly advise, thanks??? |
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-11-23 : 11:26:57
|
| What is the version of SQL Server you are accessing? Use SELECT @@VERSION from a query window against the instance you are trying to create the maintenance plan.Then, get the version information for the client tools you are using from Help | About.Verify that the version of the client tools is at least the same version as the instance you are connecting to. My guess is that your client tools have not been upgraded. If this is the case, upgrade the client tools to SP3 at least and think about applying the latest CU.If the server version is less than SP2 and the client tools are post SP2 you will also have this problem. If this is the case, you have two options - RDP to the server and run the client tools there or upgrade the server to the latest version.Jeff |
 |
|
|
derrick_goi
Starting Member
6 Posts |
Posted - 2010-12-20 : 01:18:13
|
| thank for the reply i am using the sql 2005, below is the detail Microsoft SQL Server Management Studio 9.00.1399.00Microsoft Analysis Services Client Tools 2005.090.1399.00Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)??? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-20 : 03:03:58
|
| And the server? (Exact version needed, not just that it's SQL 2005)--Gail ShawSQL Server MVP |
|
|
|
derrick_goi
Starting Member
6 Posts |
Posted - 2010-12-20 : 03:22:52
|
| The server is win 2008 server??? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-12-20 : 03:37:48
|
| What's the EXACT version of SQL Server? (Not just that it's SQL 2005, the exact version number returned by @@Version)--Gail ShawSQL Server MVP |
|
|
|
Jim Beam
Posting Yak Master
137 Posts |
Posted - 2010-12-20 : 06:46:18
|
| Derrick, using Management studio open a query to the Master database, copy-paste 'Select @@Version' (not including the apostrophes!!) and hit F5.Mine returns this...Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3) |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-12-20 : 16:22:01
|
| Once you have verified the version on the server you are connecting to - you need to upgrade your client tools to at least that version. Your client tools are RTM version and there were a lot of issues with that version and maintenance plans.In fact, you really want both your client tools and the server upgraded to at least SP3 if possible (SP4 just now came out, or I would recommend that version).Jeff |
|
|
|
|
|
|
|
|
Create Maintenance Plan failed (SQL2005)