question

reni avatar image
reni asked

Page Granularity Locking

I am trying to shrink a database, but I keep getting an error cannot use the PAGE granularity hint on the table dbo.subreport because locking at the specified Granularity is inhibited. Can someone tell me how to fix this?

sql-server-2005lockingshrink-database
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

mrdenny avatar image mrdenny commented ·
Your getting the PAGE hint error when you shrink the database? Can you provide the exact error (copy and pasted) that you get back?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.