error '80004005' SQL7

Hello!
When I run this code:
[SELECT COUNT(DISTINCT UserLogin.companyid) AS
countCompanys, COUNT(UserLogin.id) AS countUsers,
UserLogin.AgentID, UserLogin1.OrderBy FROM UserLogin
INNER JOIN UserLogin UserLogin1 ON UserLogin.AgentID =
UserLogin1.ID GROUP BY UserLogin.AgentID,
UserLogin1.OrderBy ORDER BY UserLogin1.OrderBy]
I get this message:
[Microsoft OLE DB Provider for ODBC Drivers
error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Process ID
7 attempting to unlock unowned resource PAG: 7:1:71555.]
I am using SQL7 with SP4.
Never had this problem before!
Thanks to any replyDid you try running DBCC CHECKDB and see if it points out any consistency or
other errors in your database?
http://www.aspfaq.com/
(Reverse address to reply.)
"shimmy" <shimmy@.rampal.com> wrote in message
news:82b701c477ce$c7371260$a501280a@.phx.gbl...
> Hello!
> When I run this code:
> [SELECT COUNT(DISTINCT UserLogin.companyid) AS
> countCompanys, COUNT(UserLogin.id) AS countUsers,
> UserLogin.AgentID, UserLogin1.OrderBy FROM UserLogin
> INNER JOIN UserLogin UserLogin1 ON UserLogin.AgentID =
> UserLogin1.ID GROUP BY UserLogin.AgentID,
> UserLogin1.OrderBy ORDER BY UserLogin1.OrderBy]
> I get this message:
> [Microsoft OLE DB Provider for ODBC Drivers
> error '80004005'
> [Microsoft][ODBC SQL Server Driver][SQL Server]Process ID
> 7 attempting to unlock unowned resource PAG: 7:1:71555.]
> I am using SQL7 with SP4.
> Never had this problem before!
> Thanks to any reply
>