Thank you both. Warm regards, Hope

Thank you Jeffery. I will keep both methods on hand. For simplicity I think I try the second method first. Warm regards, Hope

This will take a bit to digest. I will be back though. Warm regards,

Thank you for the explanation.

If I'm not imposing on your good will below is the code I used to create the messages, queues, et.al. and below that is the procedure...

Should the END CONVERSATION be wrapped in an IF to avoid ending a conversation with a NULL handle ?

For various reasons, it is normal for a Queue's activation procedure to...

Hi,

Problem 1) taken care of: sp_notify_operator works with the parameter @profile_name not the parameter @profilename. The Help on sp_notify_operator is wrong.

So that just leaves me wondering about problem...

Found the problem, the admin login I was using was given only the Public server role. It should have been identical to the production login but was not.

Hi, regarding Service Broker I am testing. The message types and everything are set up and seem to be fine. I can run the procedure that begins the conversation. I...

Jeff, sorry to be so dense, I did not have the file open with another application when I ran the bcp. The xp_cmdshell @echo command created the file in the...

Did you, by any chance, have the file you create with the @ECHO command open in a word processor or NotePad when you tried to run the BCP command?

--Jeff...

I use five temp tables and four have indexes. I'm pretty sure I have them tuned as best they can be, tuning the fourth table cut 45 seconds off.

I...

Jeff, I used your example and I have the following error

SQLState = HY000, NativeError = 0

Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file

I have verified that I can...

Thank you to bhovious, Lowell and Jeff for helping me. I learn from all and it raises my abilities. Once I implement use of bcp in my work I'm sure...

Hi again,

I got it done! Did the same delete a second time only with firstcontact < secondcontact.

DELETE FROM T1

FROM #header T1, #header T2

WHERE T1.fkProjectID = T2.fkProjectID

AND T1.ContactType < T2.ContactType

Warm...

Hi again,

I found how to eliminate duplicate contacttypes for the same fkProjectID as below, keeping the newest by DateCreated. So now I think I only have to delete the 'firstcontact'...