Thank you for the quick reply - that seems to work - with one caveat, the Parent record needs to have DateChanged set (currently it was NULL).

I can modify the data...

That was it - thanks, I had run across this a while back and totally forgot about that (obviously).

I agree Remi - and if this was heavily used / a source of contention, then I would. Mostly, I was trying to make sure I was not missing /...

Yes, in this particular instance it would be possible to totally rewrite all 3 of the sprocs to accomplish this task.

The original question was mostly for my education/knowledge - as...

Unfortunately, changing the parameter from a single userID to a concatenated list is not an option, or I could use a UDF to return them to a parameter and pass...

Interesting thread - hopefully, you can help me with something similar.

One cursor usage that I'm trying to resolve is one in which the result set is passed to another sProc...

The Quest tool is the one I had seen, thanks.

I'm considering evaluating this as well - anyone have experience with this or similar products? My primary goal is to fine tune some stored procedures and views.

Thanks for the article - can you advise if there is something in SQL2005 to convert exsting DTS packages? If so, how accurate does it appear to be (if you...

Over the past 3.5 years we have tried 4 different anti-spam solutions.

The first two were traditional locally installed software products. One from our AV...

I do something similar, but I do it in the middle tier. We use only sprocs (no in-line sql) - using MS .Net / ADO.Net. Each sProc is invoked via...

How to do what?

Our issue turned out to be in the COM object. Invoking it as a service vs loading in a separate user context resolved our issue.

Both using 2.7 - however, this would appear more DCOM related - in that it works properly when run on the server, just not locally. The lack of any DCOM...

Thanks, but as I mentioned I have verified the dcom settings and am not getting any DCOM errors.

Yes - single domain and the account I am testing with has Domain Admin priv.