I have a select query with join on some view and locks as (readpas,updlock) after executiong this query it executes the same query with little modification( no locks etc). This sequence of query executes fine in SQL server 2000/2005.
When I am executing same seq in sql server 2008 through application, I am getting timeout for second query.
Can someone please suggest what can be the reason?
I cannot post the query.Cheers!!! Vatsa
View Complete Post