x
login about faq Site discussion (meta-askssc)

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?

more ▼

asked Nov 22 '09 at 12:19 PM in Default

reni gravatar image

reni
1 1 1 1

Your getting the PAGE hint error when you shrink the database? Can you provide the exact error (copy and pasted) that you get back?

Nov 30 '09 at 04:20 AM mrdenny
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1835
x33
x31

asked: Nov 22 '09 at 12:19 PM

Seen: 1316 times

Last Updated: Nov 23 '09 at 05:48 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.