ALLOW_PAGE_LOCKS index attribute

mfc2mfc2

For the ALLOW_PAGE_LOCKS=ON|OFF attribute of indexes in SQL Server 2005, SQL Compare recognizes the differences, but will not synchronize these differences. If you add this attribute to an index in dev, and go to sync with production, it will recreate the index, but will not add this attribute even if the attribute is the only difference between the two indexes.

-Mike Chabot

JonathanWatts

Hi Mike,

Thanks for your post. I have just tested this on SQL Compare 5.0 and 5.1 with a table where the only difference is the ALLOW_PAGE_LOCKS attribute the of the index. Is it possible for you to post the schema of the offending tables to see if that sheds any light on the problem?

Many thanks,

Jonathan

mfc2mfc2

I found the problem. One database was running SQL Server 2005, the other was running SQL Server 2000. That option did not exist in the 2000 version.