Ahhh, that did it. Thanks so much!

Thanks Sean!

This is definitely a step in the right direction. It now returns the data with all of the trandate's. So, each ItemKey is listed multiple times with...

Thanks everyone. I should have figured that out, I have just never seen it coded out in that way.

Thanks again!

I have nothing open pointing to the DB. I have even tried using code:

Use Master

ALTER DATABASE voicelink SET MULTI_USER WITH NO_WAIT

still get error that the db is in use.

That did the trick. Thank you so much Phil!