Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_wood99
Yak Posting Veteran
70 Posts |
 Posted - 2011-07-08 : 06:20:34
|
| I am getting error when attempting to run a stored procedure that contains 'forceseek' in a new test environment running SQL 2008 R2 Developer edition. The stored proc was scripted from a UAT environment yesterday which is running SQL 2008 R2... The only difference appears to be the version, but I thought dev was supposed to be functional identical... can't see any other db settings that would affect this. Any suggestions ?Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN. |
|
|
|
|
|
identical stored proc not working in diff env