pk_dtproperties Question

From: John (John_at_discussions.microsoft.com)
Date: 10/05/04 

Date: Tue, 5 Oct 2004 12:37:04 -0700

I'm having some weird locking in SQL Server 2000 and I look the locks with a
modified sp_locks it shows thousands of the locks below. But I can't find
any code or SQL scripts that use that table and the table has 0 rows.

Has anyone seen this?
thanks
Johh

PrePressAutomation pk_dtproperties DB S
PrePressAutomation pk_dtproperties KEY Range
PrePressAutomation pk_dtproperties PAG IS
PrePressAutomation pk_dtproperties PAG IX
PrePressAutomation pk_dtproperties TAB IS
PrePressAutomation pk_dtproperties TAB Sch-S

Relevant Pages

  • Re: Detecting Table Locks?
    ... And no its not a problem with the sql as to why the operation is taking ... A damn fair use of SQL Server if you ask me (isnt that one of its ... Yes, when your are disconnected there is no locks, but when you call ... The OP is talking about 5 minutes of locking, in my idea that can never be ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: row vs page locking...
    ... so they automatically escalate to page level locks. ... 'Lock Escalation' - see Books Online. ... SQL Server 2005 is going to have a Snapshot ... Good old fashioned locking is less sexy, but I find, more productive! ...
    (microsoft.public.sqlserver.server)
  • Re: Repeatable read. What is it exactly...
    ... SQL Server will hold locks on the data you have read ... can change change the data until you commit or rollback. ... SQL Server locks the data you read. ... > as transaction Isolation levels go. ...
    (microsoft.public.sqlserver.server)
  • Re: Locking in SQL Server and Oracle
    ... I am glad you would like to stay with SQL Server :-) ... > hard it would be to convert to Oracle during our next PeopleSoft upgrade. ... > had thought that since databases are databases, tables are tables, and SQL ... > uses row-level locks exclusively. ...
    (microsoft.public.sqlserver.server)
  • Re: Database Blocking Redux
    ... SQL Server stores rows on pages and pages on extents. ... Given the number of locks to manage, it's rare for SQL Server to lock individual rows. ... If SQL Server finds there are too many pages locked, it escalates locks to the entire extent and then to the entire table. ... When reading rows using SqlDataReader, does reading the next row release the lock on the previous row? ...
    (microsoft.public.dotnet.framework.adonet)