Readers take shared locks. Changing the data requires an exclusive lock, which is incompatible with a shared lock. Hence the blocked process waits.

It shouldn't have to wait long though. As...

Books Online

---

DBCC CHECKIDENT ( 'table_name', RESEED, new_reseed_value )

Current identity value is set to the new_reseed_value. If no rows have been inserted to the table since it was created, the first...

Depends

What was the blocked process doing?

What was the blocking process doing?

Generally you fix blocking problems by optimising code and ensuring that indexes are adequate.

Please don't cross post. It wastes people's time and fragments replies.

No replies to this thread please.

Direct replies to the following:

http://www.sqlservercentral.com/Forums/Topic500040-150-1.aspx

Technical advice only here, cause I have no knowledge of USA laws.

Have you considered enabling C2 or Common Criteria logging? They'll both produce a lot of data but they will...

You could add the login to the sysadmin fixed server role. It gives the account full systed admin privilidges, but if you're OK with that...

Other than suggesting that SQL 2000 questions should go in the SQL 2000 forums?

Dunno. I'm still...

TheSQLGuru (5/13/2008)

---

I believe the distance limit for LVD SCSI is 25 meters. not sure of other, newer technologies, but 25meters gives a LOT of room for drives to attach...

Missed that. Thanks

The sp_adduser/sp_addrole are deprecated in SQL 2005

Rather use CREATE USER ... and CREATE ROLE ...

I'll go with a simple partitioned table (partitioned on the day of week, or the day of month, depending on data volumes) Don't see any need to add the complexity...

magarity kerns (5/13/2008)

---

The solution suddenly came to me after I re-read this sentence: Get the "pedestal" version of...

jamiejulius (5/13/2008)

---

One more question to help me understand what's happening.

The checkpoint process kicks in as a result of accumulated write activity, which needs to be flushed to the disk....

Try running the query from a querying tool (query analyser). It's easier to see the SPID and removes any possibility of the slow down coming from somewhere other than SQL.

If...

I had anj idea it was the problem at the beginning, wasn't sure.

Jamie: The root problem is that your IO sustem is not adequate for the load you're putting on...