Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2007-06-01 : 16:55:42
|
| Hi,I checked the server log and it It keep showing one of my table with this error, how can I fix it, the tables don't have any index attached to it. This is the only table have that message.Message showing in the server log"Cannot use the page granularity hint on the table "dbo.Table1" because locking at the specified granularity is inhibited"Thanks for your help! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-02 : 00:35:34
|
| Which query was running at that time? Used any lock hint in the query? |
 |
|
|
mapperkids
Yak Posting Veteran
50 Posts |
Posted - 2007-06-02 : 12:59:27
|
| It is showing in server log and how do I know what query is running. what is lock hint in query?Thanks! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-03 : 01:46:48
|
| It may happen when you shrink db and table doesn't have clustered index. |
|
|
|
mapperkids
Yak Posting Veteran
50 Posts |
Posted - 2007-06-03 : 11:04:27
|
| rmiao,The database is set as auto "SHINK", but why I need the Clutered indext for auto SHINK? currently, that table don't have any indexes in it.Thanks! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-03 : 20:16:42
|
| I didn't say it's the case on your server, but what I said is a known issue. Just FYI. By the way, auto shrink is still shrink. |
|
|
|
|
|
|
server log error about one of the table.