I believe I have discovered the problem since it is no longer happening.

I was getting all those errors because the changes made by the dynamic properties task were not all...

And of course, I was so focused on describing the problem I failed to ask any questions.

Has anyone seen these errors before?  I have seen the "Multiple-step OLE DB operation...

I just spoke to our System Engineer and he said he only had to disable the write caching and that stabilized our environment.  We have not seen this problem again...

Forgive me for not posting the solution.  I intended to, but must have forgotten.  I just confirmed with our DBA that what I remembered as the solution was correct.

We had...

Sorry, in my haste to post my problems I think I failed to give enough info.  We are using SQL Server 2000 and was trying to use the FOR XML option...

Thank you all for your comments.  They are very helpful.

Can anyone tell me why the MUMPS (and/or CACHE) database has not been replaced by a transactional database?  Is it just a...

Thanks for the replies.  Forgive my lack of knowledge.  What is a VAX?  What does YMMV mean?

I only know transactional databases (specifically some Access and a lot of SQL Server). ...

Let me answer the responses to my article so far in this way.  First, this article was not written to discuss this subject in any depth.  It is targeted toward...

Open two windows in Query Analyzer.  In the first window put:

Begin Transaction

then update a row in a table.

Execute.

In the second window execute the same update statement.  This one should get...

Thanks for the comments.  My understanding of the QOD is that it is good when it makes you think.  If it is too easy then you won't have to think...

When I was creating this QOD, it was my intent to violate the unique index.  When I ran my first test and realized it was the trigger, I thought that...

Hmm, a curious lack of comments on this QOD.  Did I make it too simple?  Is it too clear?  Are questions like this useful?  Or are they a waste of...

Perhaps you can use what dmbaker sent along with this code which gives you the PackageID.  That equates to the ID column in sysdtspackages:

Function Main()

 Dim ObjectPackage

 Set ObjectPackage = DTSGlobalVariables.Parent

 MsgBox ObjectPackage.PackageID

 DTSGlobalvariables("gvPackageID").value...

If only one of these DTS packages is running at any given time and that package can access all your SQL Servers (and assuming you don't have too many) and...

I think the tuning wizard works fine.  I like it for analyzing a work load.

I usually don't use it since my tuning efforts are usually focused on one SP at...