My SQL Server is suffering from DTS jobs diappearing. I
have 7 jobs that excute daily at 4am. Now the jobs do not
appear in the designer and execute correctly except
tehres nothing to execute.

The KB article talks about paying for a fix, is that
right? A SP created a bug I didnt have and now I have to
pay or wait for another SP?

Tell me it isn't so?

Tony

In article <2b1e01c37969$c413e130$a601280a (AT) phx (DOT) gbl>, TonyB wrote:
This fix if that is what you need, I have seen this problem when using
text files with > 23 columns, is available from Microsoft. It is my
understanding that although they may take your Credit Card details if
the patch is what you want then you will not be charged. If on the
other hand this patch is not what you require then that is a different
ball game.


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

The KB article is talking about a bug where the DTS Designer
or Enterprise Manager shut down unexpectedly when you try to
open them. You may or may not get an access violation when
this happens. I'm not clear on how this relates to what you
describe though. However, as the article indicates, the fix
is included in the security patch for Microsoft Security
Bulletin MS03-031 which is currently available for download.
In addition, when you call MS support to get a hot fix, your
credit card isn't charged.

-Sue

On Fri, 12 Sep 2003 13:09:26 -0700, "TonyB"
<snaayk (AT) yahoo (DOT) com> wrote: