I think that's what I just said. You need to attach to the process in VB6. But, you don't run in debug, you just attach. Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

It runs distinct on the set before returning it from the query. You can see this using execution plans. --------------------------- Blogging about SQL, Technology and many other things

Bleh, figured it out. Needed to generate the certificate against our internal trusted certificate provider.

Dang... The pain..... Well, thanks for your help anyways.