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?
Nov 22 '09 at 12:19 PM
Nov 23 '09 at 05:48 AM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Nov 22 '09 at 12:19 PM
Seen: 5207 times
Last Updated: Nov 23 '09 at 05:48 AM
what is sql server locks and how to audit them?
DBCC SHRINKFILE Error
SQL Server 2005 Locking Escalation Problem?
Please advise on why this deadlock and slowness problem happens?
SQLCMD Script Is Locking Detached Database Files Objects
DBCC ShrinkFile - better to do lots of little shrinks, or one big shrink?
Shrink file suspended for hours
Deadlock Problem With UPDATE
Shrinking is not completing in SQL Server