We use a similar system to this to monitor all our servers. Had a look at Idera SQL Job Manager but it ran very slowly on my machine and...

I'm just going to use this to check some remote machines once a day for now, nothing mission critical.

great article. Having a look at using at the moment. Love that you included a pdf with more details and screenshots.

These were testing servers that we had multi versions on and even though SMSS has pretty much everything a number of users weren't happy having to use a new tool...

Enterprise Manager wouldn't load up. It came up with a blank error message and closed. In the end Enterprise Manager was reinstalled. The 2005 Management Studio worked...

I've had a problem with SQL 2000 Enterprise Manager becoming corrupt when 2005 std was installed. The database installs were all fine, just the sql 2000 tools needed sorting...

I get problems like that from time to time. I usually check that I can connect via the IP address using Query Analyzer and that the server is actually...

Thanks for all the replies - I have a better understanding of why some of the indexes are used now. I only have to work out which ones are...

Thanks for the reply.

I'm going to try running the app against it shortly. Did you have to tell your query to use the index when you had a yes/no...

Sure,

After talking to Microsoft and forwarding on SQL exception logs and after a while a Memory dump log they gave a link to the following article.

http://support.microsoft.com/Default.aspx?id=842465

After speaking to...

If anyone is still interested, this issues has been resolved. It was caused by an issue in the CPU and corrected with a BIOS update.

I've emailed it to you. Thanks for having a look.

@@Servername is correctly set as the server name and isn't null.

I've reindexed all the tables and still see the problem.

It seems that the SPID thats causing the problem is the Replication Distribution Agent. Any ideas?