You can determine the index by looking in sysobjects where xtype = 'U' and id = 357576312,
and if you join that to sysindexes you can determine which index as well.
Jeff
Trevor Weir <mssqldba-ezmlmshield-x80953913.[Email address protected] wrote:
It means that the SQL process #39 is putting a lock on one of the indexes in
the continuum database
Trevor
-----Original Message-----
From: Emer Ryan
[mailto:mssqldba-ezmlmshield-x22861627.[Email address protected]
Sent: Friday, July 29, 2005 6:00 AM
To: LazyDBA Discussion
Subject: what does this mean?
-- Dynamic SQL
update ##lockinfo39 set [Index] = name from
[continuum].[dbo].[sysindexes] where id = 357576312 and indid = 2 and
[Database] = 'continuum' and [IdxID] = 2
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
________________________________________________________________________
This incoming e-mail has been scanned for all viruses by Star Internet
for Charter UK.
________________________________________________________________________
****************************************************************
Charter UK provides customer intelligence software for consumer affairs
professionals, customer service managers and marketing strategists.\par
Established with 14 years experience in Customer Experience Management
(CEM), Charter UK promotes public sector and corporate best practice through
the proactive management of feedback across all communication channels.\par
The company's flagship product, Charter Continuum (TM), provides
organisations with a corporate-wide solution for managing all forms of
feedback in one integrated and centralised system for true competitive
advantage. Charter software and services improve customer loyalty, increase
customer retention and provide a rapid return on investment.\par
Charter Continuum (TM) incorporates the powerful, customisable reporting
capabilities of Business Objects (R) for customer experience management and
trend evaluation for business process improvement. Charter Continuum (TM)
incorporates a flexible diary management system and call-logging wizard for
the management of customer intelligence, feedback data capture and
analytics.\par
Join the world-class companies using the Charter brand of products and
services such as McDonalds Restaurants, Starbucks Coffee, Staples, Rowenta
and First Choice. For more information on how Charter can enhance your
corporate performance visit www.charter-uk.com \par
*****************************************************************
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet for Charter
UK. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page