Not sure if this is the most optimal work around, but is does work. Edit the host file on all three

servers...your principal, your mirror and your witness. In...

I thought about that but my problem will remain the same. What is the code to send an email if my query results are true?

I was able to figure out a solution to this problem. I ended up adding one index in SQL 2005 and brought my query time to under 1 second.

I ran the queries and compared their actual execution plans. In SQL 2005 the query is doing a Table Spool (Lazy Spool) and that is where the slow down...

Yes it will update stats....

There was a article in SQL Server Magazine comparing the two. They both have their strengths. I will see if I can find the article online and send...