16 reputation
1
bio website
location
age
visits member for 2 years, 1 month
seen May 27 at 10:51

Sep
25
awarded  Student
Sep
25
comment SQL Server 2008 R2 clustered index issue
I too agree with you both. On facing the issue, First thing which I checked is whether it is static cursor or dynamic cursor but that is not the point, because no update is done on clustered index columns. Moreover, as already mentioned, dropping of clustered index makes the cursor to run perfect, existence of clustered index makes it run infinite times. Here, there is no point in considering whether it is a dynamic cursor or static cursor. Regards, K.P.Senthil Kumar
Sep
25
asked SQL Server 2008 R2 clustered index issue