From: Paul Ibison on
OK - then the only option is to test on SP2 and see if it is possible there.
I'd still be tempted to add a step to the automatically generated job but I
understand your concerns.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com




From: Peter Yang [MSFT] on
Hello Charts,

I also tested this in my test environment in both SP1 and SP2 CTP2
environment and I recevied the same error message as you encountered. I
think this is a product limitation in 2005 that this kind of job cannot be
created unless it is created by wizard since there are some related
information to be referenced when executing the job.

I do understand your concerns on this behavior since you have many
databases and I think it's good idea to be able to do this as SQL 2000.
Please rest assured this issue is routed to the product team. In the
meantime, I also encourage you submit via the link below

http://lab.msdn.microsoft.com/productfeedback/default.aspx

Please let's know if you have any further comments or feedback. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================


From: Charts on
Thanks Peter for looking into this issue. I'll submit this issue to Microsoft
SQL 2005 feedback.
Charts

"Peter Yang [MSFT]" wrote:

> Hello Charts,
>
> I also tested this in my test environment in both SP1 and SP2 CTP2
> environment and I recevied the same error message as you encountered. I
> think this is a product limitation in 2005 that this kind of job cannot be
> created unless it is created by wizard since there are some related
> information to be referenced when executing the job.
>
> I do understand your concerns on this behavior since you have many
> databases and I think it's good idea to be able to do this as SQL 2000.
> Please rest assured this issue is routed to the product team. In the
> meantime, I also encourage you submit via the link below
>
> http://lab.msdn.microsoft.com/productfeedback/default.aspx
>
> Please let's know if you have any further comments or feedback. Thank you.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
>
> =====================================================
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> ======================================================
>
>
>