Thank you for suggesting "the asynchronous statistics update option", per your suggestion I just tried it and it works just fine.  Appreciate your help.  David

and you are saying that the snapshot refresh was ONLY for the part of the snapshot affected?  (i.e., only included TableA?).  I thought I tried something similar; but when I...

look for errors in the event log.  I seem to recall that there were 17 "dcom" errors and that they had a link to MSDN to tell you how to...

Stephanie, Ed and Tom,

Thanks also for taking the time to respond to my post.  I do apprediate you very much.  The information on the inner join was particularly interesting.  Hopefully...

Aaron West, thank you for such a comprehensive list of things to try.  My hours are limited for this test, and when I executed the actual query on production there...

This sounds like EXACTLY what I am trying to develop... and I KNOW that my requirements are not so unique that it hasn't been done before.  This should be a...

Let me see if I understand your situation correctly.  You had replication set up and had a publisher, a distributor, and a subscription (or more).  You have now deleted replication,...

I agree that this is necessary in some situations... and it seems you have taken the necessary precautions by creating a back door before removing the builtin admins... at a...

>> Could anyone out there give me some advice?

Yeah.  Keep your resume updated.

Seriously (although that is not bad advice), I understand the security officer's position on the server configuration.  Ideally...

I have heard people call it "Daylight Savings Time" before... never heard them call it "Daylights Savings Time"...

The correct reference is "Daylight Saving Time"... as in there is more daylight...

okay, nobody has responded.  I'm going to bite and ask "why?"

WHY are you removing the builtin/admins?  Exactly what procedure did you use to do so?  Is there really a business...

how long does it stop for?  what is happening when it stops?  what type of replication are you using?  If a new snapshot is being created, you might take a...

there is also a query wizard in the query analyzer...

Maybe it's just me... maybe it's just today; but it seems like, more and more, and particularly in THIS forum, that people are asking questions that could be answered with...

No need to cross-post.  The regulars here watch the forums they know regularly.