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:

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
RupeshIt 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:
> 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

Maintain Transaction even if need to loop through multiple data

I have a ADP app that executes several SPs with a click of a button
Now I want to combine these SP into 1 transaction so that it can
rollback even if one SP fails.
Problem is several SP need to process recordsets in vba so I have made
while loops in vba for them. I do this to avoid cursors as they no good
performers. My choice of avoiding cursors has broken the 'transaction
boundary' therefore I cannot do a roll back for these. How can I still
use store procedures but still maintain performance and be able to roll
back all the SPs if any of them fails?Have you considered rewriting the procs in set based fashion such that
you don't need to call them in a loop? A for each loop is really just a
cursor by another name. Without seeing what you are doing it's
difficult to advise otherwise.
--
David Portas
SQL Server MVP
--|||Thanks for the hint -> set based technique.
I've found what I've been looking for:
http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/eb09130dcb79c392/d8924a2b73888ca4?lnk=st&q=stored+procedure+set+based&rnum=3&hl=en#d8924a2b73888ca4|||I got another problem.
I got this dynamic sp:
create procedure spFindData()
as
declare @.statement varchar(255),@.intYear int,intCount int
set @.intyear = 2010
while @.intyear >=2004
begin
select @.statement = "select count(*) from sales' + @.intYear
-- I want to assign the result of @.statement to @.intCount, how?
if (@.intCount>0)
begin
return @.intYear
end
@.intYear = @.intYear -1
end

Mailing Reports

Hi,
I am rendering a report in PDF Format when a user needs in my Web Form(on
click of a button)
When this report is rendered in PDF format, Is there a way to send him the
report by Email.
An Email has to be sent when a report is rendered by a particular user.
Is there an option for this...
Thanks
KiranKiran:
I was coming in to ask a similar question. I know what you want to do can be
done through subscriptions, and I have looked at the database table where
subscriptions are stored and I believe it would just be a matter of inserting
a onetime subscription line into the subscription table. But what I want to
know is there any resource out there taht tells you how to add lines to the
subscription table. I have been thinking of purchasing hitchhikers guide but
I am unsure if it is going to help me with anything I do not already know.
"Kiran" wrote:
> Hi,
> I am rendering a report in PDF Format when a user needs in my Web Form(on
> click of a button)
> When this report is rendered in PDF format, Is there a way to send him the
> report by Email.
> An Email has to be sent when a report is rendered by a particular user.
> Is there an option for this...
> Thanks
> Kiran
>
>|||Since you have your own webform here is another option for you (although
doing a one time subscription will work as well) but you might find this
easier. Save the PDF as a file and then send it using the following SMTP
client. This SMTP client requires no install of any mail client. You need to
have a SMTP server somewhere for this to work. It is very easy to use and is
widely used in the SQL Server community.
http://sqldev.net/xp/xpsmtp.htm
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kiran" <Kiran@.nospam.net> wrote in message
news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am rendering a report in PDF Format when a user needs in my Web Form(on
> click of a button)
> When this report is rendered in PDF format, Is there a way to send him the
> report by Email.
> An Email has to be sent when a report is rendered by a particular user.
> Is there an option for this...
> Thanks
> Kiran
>|||Hi Bruce,
How will I save the PDF on the server so as to mail it.
Thanks
Kiran
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:eBl8qd3DFHA.576@.TK2MSFTNGP15.phx.gbl...
> Since you have your own webform here is another option for you (although
> doing a one time subscription will work as well) but you might find this
> easier. Save the PDF as a file and then send it using the following SMTP
> client. This SMTP client requires no install of any mail client. You need
> to
> have a SMTP server somewhere for this to work. It is very easy to use and
> is
> widely used in the SQL Server community.
> http://sqldev.net/xp/xpsmtp.htm
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Kiran" <Kiran@.nospam.net> wrote in message
> news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
>> Hi,
>> I am rendering a report in PDF Format when a user needs in my Web Form(on
>> click of a button)
>> When this report is rendered in PDF format, Is there a way to send him
>> the
>> report by Email.
>> An Email has to be sent when a report is rendered by a particular user.
>> Is there an option for this...
>> Thanks
>> Kiran
>>
>|||Bruce; That was very helpful.. but is there a reference to where I can add
the subscription to the database through my application?
thanks
"Bruce L-C [MVP]" wrote:
> Since you have your own webform here is another option for you (although
> doing a one time subscription will work as well) but you might find this
> easier. Save the PDF as a file and then send it using the following SMTP
> client. This SMTP client requires no install of any mail client. You need to
> have a SMTP server somewhere for this to work. It is very easy to use and is
> widely used in the SQL Server community.
> http://sqldev.net/xp/xpsmtp.htm
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Kiran" <Kiran@.nospam.net> wrote in message
> news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> > Hi,
> >
> > I am rendering a report in PDF Format when a user needs in my Web Form(on
> > click of a button)
> >
> > When this report is rendered in PDF format, Is there a way to send him the
> > report by Email.
> >
> > An Email has to be sent when a report is rendered by a particular user.
> >
> > Is there an option for this...
> >
> > Thanks
> > Kiran
> >
> >
>
>|||To add a subscription from you web app you have to use soap (web services)
if you have been using URL integration then you need to learn how to use the
web services to accomplish this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Patrick K" <PatrickK@.discussions.microsoft.com> wrote in message
news:162C8BD3-843B-44FE-A968-3A08770105E4@.microsoft.com...
> Bruce; That was very helpful.. but is there a reference to where I can add
> the subscription to the database through my application?
> thanks
> "Bruce L-C [MVP]" wrote:
> > Since you have your own webform here is another option for you (although
> > doing a one time subscription will work as well) but you might find this
> > easier. Save the PDF as a file and then send it using the following SMTP
> > client. This SMTP client requires no install of any mail client. You
need to
> > have a SMTP server somewhere for this to work. It is very easy to use
and is
> > widely used in the SQL Server community.
> >
> > http://sqldev.net/xp/xpsmtp.htm
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Kiran" <Kiran@.nospam.net> wrote in message
> > news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> > > Hi,
> > >
> > > I am rendering a report in PDF Format when a user needs in my Web
Form(on
> > > click of a button)
> > >
> > > When this report is rendered in PDF format, Is there a way to send him
the
> > > report by Email.
> > >
> > > An Email has to be sent when a report is rendered by a particular
user.
> > >
> > > Is there an option for this...
> > >
> > > Thanks
> > > Kiran
> > >
> > >
> >
> >
> >|||I know it is possible but I haven't been programming asp.net for awhile now
so I can't help you with that.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Kiran" <Kiran@.nospam.net> wrote in message
news:%230kCjB4DFHA.1496@.TK2MSFTNGP14.phx.gbl...
> Hi Bruce,
> How will I save the PDF on the server so as to mail it.
> Thanks
> Kiran
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:eBl8qd3DFHA.576@.TK2MSFTNGP15.phx.gbl...
> > Since you have your own webform here is another option for you (although
> > doing a one time subscription will work as well) but you might find this
> > easier. Save the PDF as a file and then send it using the following SMTP
> > client. This SMTP client requires no install of any mail client. You
need
> > to
> > have a SMTP server somewhere for this to work. It is very easy to use
and
> > is
> > widely used in the SQL Server community.
> >
> > http://sqldev.net/xp/xpsmtp.htm
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Kiran" <Kiran@.nospam.net> wrote in message
> > news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> >> Hi,
> >>
> >> I am rendering a report in PDF Format when a user needs in my Web
Form(on
> >> click of a button)
> >>
> >> When this report is rendered in PDF format, Is there a way to send him
> >> the
> >> report by Email.
> >>
> >> An Email has to be sent when a report is rendered by a particular user.
> >>
> >> Is there an option for this...
> >>
> >> Thanks
> >> Kiran
> >>
> >>
> >
> >
>|||I have a similar question.
I am using the email provider available out of the box with reporting
services. I am on a flat network using 2 separated domains (resource and
user)and Routed IP schemes. The companies email is handled offsite using an
SMTP server that requires the user to login. There does not appear to be an
option to do this using the out of the box delivery method. And
unfortunately I do not know enough about setting up my own SMTP server
locally. I am trying to mail the reports from the resource domain to the
user domain.
--Eric Cathell, MCSA
"Kiran" <Kiran@.nospam.net> wrote in message
news:%23Tr1E%232DFHA.512@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I am rendering a report in PDF Format when a user needs in my Web Form(on
> click of a button)
> When this report is rendered in PDF format, Is there a way to send him the
> report by Email.
> An Email has to be sent when a report is rendered by a particular user.
> Is there an option for this...
> Thanks
> Kiran
>