pk_dtproperties Question

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
PrePressAutomationpk_dtpropertiesDBS
PrePressAutomationpk_dtpropertiesKEYRange
PrePressAutomationpk_dtpropertiesPAGIS
PrePressAutomationpk_dtpropertiesPAGIX
PrePressAutomationpk_dtpropertiesTABIS
PrePressAutomationpk_dtpropertiesTABSch-S
Hi
pk_dtproperties is the primary key on dtproperties which is used for
database diagrams
http://groups.google.com/groups?hl=e...dt properties
John
"John" wrote:

> 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
> PrePressAutomationpk_dtpropertiesDBS
> PrePressAutomationpk_dtpropertiesKEYRange
> PrePressAutomationpk_dtpropertiesPAGIS
> PrePressAutomationpk_dtpropertiesPAGIX
> PrePressAutomationpk_dtpropertiesTABIS
> PrePressAutomationpk_dtpropertiesTABSch-S
>
|||Thank you John, but I don't have any database diagrams on that server. I
also tried to delete the table, but in SQL 2000 sp3a It's a system table and
will not let me delete it. Do you have any clues I'm getting locks on this
table?
Thank you
John
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> pk_dtproperties is the primary key on dtproperties which is used for
> database diagrams
> http://groups.google.com/groups?hl=e...dt properties
> John
> "John" wrote:
|||Hi John
I don't know why this should be. You may want to check the inputbuffer
for that spid http://msdn.microsoft.com/library/de..._dbcc_8v8y.asp
You may also want to check what SQLAgent and NT jobs are scheduled,
and if there are any services.
Failing that you may want to see if stopping/starting the SQL Server
service
removes the problem.
John
"John" <John@.discussions.microsoft.com> wrote in message news:<2143B280-2453-4BB4-81F0-DAF461E1050A@.microsoft.com>...[vbcol=seagreen]
> Thank you John, but I don't have any database diagrams on that server. I
> also tried to delete the table, but in SQL 2000 sp3a It's a system table and
> will not let me delete it. Do you have any clues I'm getting locks on this
> table?
> Thank you
> John
> "John Bell" wrote: