Query Runs on Development Edition but do not work on Enterprise and Standard Edition (SQL2000)
Posted on 2011-09-28
I have a stored procedure it works great on SQL Server 2000 Developer editon and the query performance is close to 1 min and then we deploy the same stored procedures on
Enterprise and Standard Edition (SQL2000) it does not work, it just keeps on running.
Any idea whats happening when we move the stored procedure to Enterprise and Standard, why it is not working?