Thank you all.

This is the information I was looking for.

Thanks!

Keith

Thanks Lowell! I'll give it a go and let you know what happens 🙂

Keith

Yes, I agree completely....

Running the query with my test DB, it will currently return 3 records (This is how it looks as received in Outlook):

ASBURY PARK-SIF Brake Tester - Monitor ...

Hi Lowell,

Thanks for your response!

The results of the query will be sent to an AD Group. Typically there will be less than 20 records.

Here is my current SP...

I will give that a try.

Thanks!

Keith

Thanks so much for taking the time to write this procedure down. I recently convered to 64 bit and was not able to get a linked server to connect....

I found the following on MSDN that covers what I am trying to do:

http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx

Thanks for getting me started in the right direction!:-D

Regards,

Keith

Hi Dugi,

Thanks for your reply and the suggestions!

You are correct, SQL Server 2003 it's not, SQL server 2000 on a W2003 box. 🙂

I will run with the information you have...