I have not seen or heard this anywhere else. Unless you can get a pattern it might be a fluke. However a few thoughts.

Do you have any apps that open...

I agree there is just so much to look for as html. You might pull a fast one if you just want the data and use the MS IE Actrive...

Sorry for putting you all in a lurch where this does not apply.

Cool something else I can add to my personal knowledge. Thanks. ANd I love the idea of check for value of 0 to verify count is accurate. I need to...

Easiest thing to do is change owenrship to DBO that way will match the table. Of course this means the user who created will not be able to change it...

I understand and it could be as simple as network timeouts on your end. But I would test from another machine. If fails on another machine my vote will go...

quote:

---

Antares686, your correct in that its not always accurate. However, (gotta hate that however) that's where rowmodcntr comes in. This value shows...

From the release notes on 2.6 and later.

quote:

---

Due to issues with clustering, this release is currently NOT supported on SQL Server 7.0...

ALways save before testing. Keep in Mind DTS has a built in versioning and if something doesn't work you can always go back without much fuss.

I think all you need is the

Main = DTSTaskExecResult_Failure

exit function

where you have need to stop here at.

No, but in the Windows Components Wizard in Add/Remove Programs under Control Panel you will find it there on the install disk. Just go in and add it.

Also, try from another machine where you are at to rulle out possible client install issue.

ANother thing to consider is how you queries are executed. If most are straight queries and not part of Stored Procedures then when you cycle the box you clear the...

Thanks Don, didn't think I was nuts. And since it was the statistics thing I was thinking of even with Auto Update Stats on it may be in acurate and...

Don't bow to me, I stole it from someone else a week or so ago and thought was cool option. I like to find new ways to do things and...