Help with sp_lock output

I am trying to figure out something in the dump of my sp_lock output
(sql server 2000)
spid Db Objectid IndId Type
Resource Mode Status
373 QADB 0 0 PAG
1:204097 S WAIT
What does an object id = 0 mean? i thought this always show the id of
an actual tableHi Derek,
The output you provided means that a shared lock is held on a page, not on a
table, hence the 0 value for objectid. Resource column states that the lock
is held on file id 1 page number 204097.
To easily work with locks and/or deadlocks, I suggest you try out the tool
called SQL Deadlock Detector. It monitors your database for locks and
deadlocks and
provides complete information on captured events. It tells you everything
you need to know (locked objects, blocked statements, blocking statements,
etc.) to solve your blocking/deadlock problems. The great thing about this
tool is it's event diagram which makes it exremely easy to see what exactly
is going on.
You can download it from here:
http://lakesidesql.com/downloads/DLD2/2_0_2007_809/DeadlockDetector2_Setup_08-09-2007.zip.
I've been using it for quite a while now (I purchased it) and find it very
handy and useful.
HTH.
"Derek" <gepetto_2000@.yahoo.com> wrote in message
news:1187376178.875402.209170@.d55g2000hsg.googlegroups.com...
>I am trying to figure out something in the dump of my sp_lock output
> (sql server 2000)
> spid Db Objectid IndId Type
> Resource Mode Status
> 373 QADB 0 0 PAG
> 1:204097 S WAIT
> What does an object id = 0 mean? i thought this always show the id of
> an actual table
>

Help with permissions issues in Sql 05 standard

I spent 3 weeks trying to solve this problem and I’m in over my head.Can someone direct me to a resource for this.I am looking for a professional MCDBA Sql Server 2005 and that can configure my server remotely, am having a problem with aspx pages that access the db.They error.It has to be some sql permissions issue,the login false but i can connect local and form the command prompt (to the server and db) but not in a page.

Thanks for help.

Whats the error message, normally some errors are very common, so they can be soved via the forums thread.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Here's the best place to start:

http://msdn2.microsoft.com/en-us/library/bb283235(SQL.90).aspx

Help with permissions issues in Sql 05 standard

I spent 3 weeks trying to solve this problem and I’m in over my head.Can someone direct me to a resource for this.I am looking for a professional MCDBA Sql Server 2005 and that can configure my server remotely, am having a problem with aspx pages that access the db.They error.It has to be some sql permissions issue,the login false but i can connect local and form the command prompt (to the server and db) but not in a page.

Thanks for help.

Whats the error message, normally some errors are very common, so they can be soved via the forums thread.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Here's the best place to start:

http://msdn2.microsoft.com/en-us/library/bb283235(SQL.90).aspx