Here is what I did. I first tried to take out the index hint by altering the stored procedure and running a sp_recompile. No success. Then I dropped and recreated...

Yes I have run a query plan. I have created the same stored procedure I am having problems with under a new name, run a query plan and SQL chooses...

I had trouble with this. Luckily it was on a non-production box. I mistakenly typed I for L in the path for the log file in the start up parameters...

Thanks for the input. That is the route I will take. Any advice for intergrated Win 2000 logins from one domain to another. My thought is to drop and recreate...

Good question. I am planning the migration to clustering and just thought restoring master would be the easiest way but maybe just moving the logins would be the easiest. Still...

I am using 2000. The SQL Server error logs are missing. SQL is only writing to the error log when it is on Server1. After fail over to Server2 no...