How can we help you today? How can we help you today?

ALLOW_PAGE_LOCKS index attribute

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
mfc2mfc2
0

Comments

2 comments

Sort by
  • 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
    JonathanWatts
    0
  • 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.
    mfc2mfc2
    0

Add comment

Please sign in to leave a comment.