Maintaintance plan error

I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
am creating new maintainance plan ,at the end when i click finish button of
the wizard,message i am getting is "one or more arguments are invalid",please
reply me what is the problem asap.
Thanks
Rupesh
It looks like some other people have been experiencing this problem. One
thing that has been suggested in another thread is to assure that you have
SP2 also of Management Studio.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
If you're interested in an alternative to the Maintenance Plans you could
have a look at a stored procedure based solution that I've made.
http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
Ola Hallengren
http://ola.hallengren.com
"Rupesh Mondal" wrote:

> I have sql server 2005 standard edition with service pack 2(9.0.3050),when i
> am creating new maintainance plan ,at the end when i click finish button of
> the wizard,message i am getting is "one or more arguments are invalid",please
> reply me what is the problem asap.
> Thanks
> Rupesh
|||Thank you for the help, my sa password was blank thats why it was not working,
now it is working fine.
Rupesh Mondal.
"Ola Hallengren" wrote:
[vbcol=seagreen]
> It looks like some other people have been experiencing this problem. One
> thing that has been suggested in another thread is to assure that you have
> SP2 also of Management Studio.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1823734&SiteID=1
> If you're interested in an alternative to the Maintenance Plans you could
> have a look at a stored procedure based solution that I've made.
> http://blog.ola.hallengren.com/blog/_archives/2008/1/1/3440068.html
> Ola Hallengren
> http://ola.hallengren.com
>
> "Rupesh Mondal" wrote:

maintaining atomicity

Hello Friends,
Iam new to this sql server arena. I have implemented a procedure which does a series of insert and update statements and all of this statements must be implemented all at once or none. But if I got error in some statements , the rest of the statements are been executed. Please suggest me a way or code snippet to achieve atomicity in a sqlserver procedure.

regards,
Ch.Praveen Kumar.Use transactions:

begin tran

insert ...

if @.@.error<>0 begin
rollback tran
RAISERROR ...
return
end

update ...

if @.@.error<>0 begin
rollback tran
RAISERROR ...
return
end

commit tran|||Thank You For Your Reply. I Will Implement It.|||Hi,
I got a small doubt here. Whenever an error encounters, how to display the sqlserver error message rather than displaying our custom message with raiseerror. Is there any way to get the error message from sql server if an error encounters such as foriegn key violation. (invalid references to pk in mastertable)|||The problem that I see is that errors come back to the client application in a "stream", much like TDS or STDOUT provide. Transact-SQL sees the most recent error, the client sees every error. Unfortunately, the formatted error message (including things like object names) is only passed to the client, I don't think that Transact-SQL can even access it (although ADO can).

-PatP

mail error

Iam unable to send out emails since we changed the system
acount name...
when I test the email name I get the following message
'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
session is not running; check the mail profile and or
SQLServerAgent service startup acount in SQLServerAgent
properties dialogue box'
the mail configeration test works ok and restarted
SQLServerAgent.. any ideasgrumy,
When you say you changed the "system account name", what exactly are you
referring to? The MSSQLServer service account name?
I am also not clear on whether your SQLServerAgent service is running or
not. The error message states that it is not running, but you are saying
that SQLServerAgent was restarted successfully. Could you clarify your
questions?
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"grumy" <anonymous@.discussions.microsoft.com> wrote in message
news:2f5e01c4289b$d6d1eba0$a301280a@.phx.gbl...
> Iam unable to send out emails since we changed the system
> acount name...
> when I test the email name I get the following message
> 'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
> session is not running; check the mail profile and or
> SQLServerAgent service startup acount in SQLServerAgent
> properties dialogue box'
> the mail configeration test works ok and restarted
> SQLServerAgent.. any ideas

mail error

Iam unable to send out emails since we changed the system
acount name...
when I test the email name I get the following message
'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
session is not running; check the mail profile and or
SQLServerAgent service startup acount in SQLServerAgent
properties dialogue box'
the mail configeration test works ok and restarted
SQLServerAgent.. any ideas
grumy,
When you say you changed the "system account name", what exactly are you
referring to? The MSSQLServer service account name?
I am also not clear on whether your SQLServerAgent service is running or
not. The error message states that it is not running, but you are saying
that SQLServerAgent was restarted successfully. Could you clarify your
questions?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"grumy" <anonymous@.discussions.microsoft.com> wrote in message
news:2f5e01c4289b$d6d1eba0$a301280a@.phx.gbl...
> Iam unable to send out emails since we changed the system
> acount name...
> when I test the email name I get the following message
> 'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
> session is not running; check the mail profile and or
> SQLServerAgent service startup acount in SQLServerAgent
> properties dialogue box'
> the mail configeration test works ok and restarted
> SQLServerAgent.. any ideas

mail error

Iam unable to send out emails since we changed the system
acount name...
when I test the email name I get the following message
'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
session is not running; check the mail profile and or
SQLServerAgent service startup acount in SQLServerAgent
properties dialogue box'
the mail configeration test works ok and restarted
SQLServerAgent.. any ideasgrumy,
When you say you changed the "system account name", what exactly are you
referring to? The MSSQLServer service account name?
I am also not clear on whether your SQLServerAgent service is running or
not. The error message states that it is not running, but you are saying
that SQLServerAgent was restarted successfully. Could you clarify your
questions?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"grumy" <anonymous@.discussions.microsoft.com> wrote in message
news:2f5e01c4289b$d6d1eba0$a301280a@.phx.gbl...
> Iam unable to send out emails since we changed the system
> acount name...
> when I test the email name I get the following message
> 'Errorr 22022:SQLServerAgent Error: The SQLServerAgent
> session is not running; check the mail profile and or
> SQLServerAgent service startup acount in SQLServerAgent
> properties dialogue box'
> the mail configeration test works ok and restarted
> SQLServerAgent.. any ideas