Deadlock : What the meaning of associatedObjectId

This is a multi-part message in MIME format.
--=_NextPart_000_0006_01C84D3C.B9609430
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
In 2005, when 1222 trace flag is activated, I get in the error log file, = among other very useful informations, this kind of message
keylock hobtid=3Dxxxxxxx dbid=3DXX = indexname=3D...objectname=3D... id=3Dlock13c50480 mode=3DS = associatedObjectId=3D72057594039304192
or
pagelock fileid=3DX pageid=3Dxxxx dbid=3DXX = objectname=3D.... id=3Dlock5f69480 mode=3DIX = associatedObjectId=3D72057594378518528
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is = related to the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant = information
Thanks Med
--=_NextPart_000_0006_01C84D3C.B9609430
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
In 2005, when 1222 trace flag is = activated, I get in the error log file, among other very useful = informations, this kind of message

keylock hobtid=3Dxxxxxxx dbid=3DXX = indexname=3D...objectname=3D... &nbs= p; id=3Dlock13c50480 = mode=3DS associatedObjectId=3D72057594039304192
or
pagelock fileid=3DX pageid=3Dxxxx dbid=3DXX &nbs= p; objectname=3D.... id=3Dlock5f69480 mode=3DIX associatedObjectId=3D7205759437851= 8528

What is the meaning of associatedObjectId?

It always starts with 72057594xxxxx and does not look like it is related to = the locked object
In my case, OBJECT_NAME and = OBJECT_ID did not return any relevant information

Thanks
Med


--=_NextPart_000_0006_01C84D3C.B9609430--Hi
This should match a waitresource in the process list and in the waiter list,
you should also should also see that database id for this which is probably 2
ie tempdb.
Check out Bart Duncan Blog
http://blogs.msdn.com/bartd/archive/2006/09/09/Deadlock-Troubleshooting_2C00_-Part-1.aspx
John
"Med Bouchenafa" wrote:
> In 2005, when 1222 trace flag is activated, I get in the error log file, among other very useful informations, this kind of message
> keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=... id=lock13c50480 mode=S associatedObjectId=72057594039304192
> or
> pagelock fileid=X pageid=xxxx dbid=XX objectname=.... id=lock5f69480 mode=IX associatedObjectId=72057594378518528
>
> What is the meaning of associatedObjectId?
> It always starts with 72057594xxxxx and does not look like it is related to the locked object
> In my case, OBJECT_NAME and OBJECT_ID did not return any relevant information
> Thanks
> Med
>|||Med,
I don't know if the associatedObjectId will help you any, although you do
have the dbid and the objectname to focus your attention. From the Books
Online article "Detecting and Ending Deadlocks"
http://msdn2.microsoft.com/en-us/library/ms178104.aspx :
associatedObjectId. Represents the HoBT (heap or b-tree) ID.
RLF
"Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
news:%23znq0EVTIHA.5516@.TK2MSFTNGP02.phx.gbl...
In 2005, when 1222 trace flag is activated, I get in the error log file,
among other very useful informations, this kind of message
keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
id=lock13c50480 mode=S associatedObjectId=72057594039304192
or
pagelock fileid=X pageid=xxxx dbid=XX objectname=....
id=lock5f69480 mode=IX associatedObjectId=72057594378518528
What is the meaning of associatedObjectId?
It always starts with 72057594xxxxx and does not look like it is related to
the locked object
In my case, OBJECT_NAME and OBJECT_ID did not return any relevant
information
Thanks
Med|||You're right...
That's the way it is documented in the books online.
To have the object name, I run a query like this
SELECT OBJECT_NAME(object_id) FROM sys.partitions WHERE partition_id =@.associatedObjectId
and it worked
What surprised me is the fact that they all started with 72057594xxxxx
It looks like partion_id is a component of two or more values...
Thanks again
Med
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:uSgP$qVTIHA.5404@.TK2MSFTNGP03.phx.gbl...
> Med,
> I don't know if the associatedObjectId will help you any, although you do
> have the dbid and the objectname to focus your attention. From the Books
> Online article "Detecting and Ending Deadlocks"
> http://msdn2.microsoft.com/en-us/library/ms178104.aspx :
> associatedObjectId. Represents the HoBT (heap or b-tree) ID.
> RLF
> "Med Bouchenafa" <com.hotmail@.bouchenafa> wrote in message
> news:%23znq0EVTIHA.5516@.TK2MSFTNGP02.phx.gbl...
> In 2005, when 1222 trace flag is activated, I get in the error log file,
> among other very useful informations, this kind of message
> keylock hobtid=xxxxxxx dbid=XX indexname=...objectname=...
> id=lock13c50480 mode=S associatedObjectId=72057594039304192
> or
> pagelock fileid=X pageid=xxxx dbid=XX
> objectname=.... id=lock5f69480 mode=IX
> associatedObjectId=72057594378518528
>
> What is the meaning of associatedObjectId?
> It always starts with 72057594xxxxx and does not look like it is related
> to the locked object
> In my case, OBJECT_NAME and OBJECT_ID did not return any relevant
> information
> Thanks
> Med
>
>

dd-mmm-yy date format?

Is there any way to make dates come out like "11-oct-07"? There does not
appear to be a built-in format like this. Is there a secret method?
MauryHi
select replace(convert(varchar(20),getdate(),106),' ','-')
"Maury Markowitz" <MauryMarkowitz@.discussions.microsoft.com> wrote in
message news:280EFB54-FE00-4153-A51F-C4D539D8EF12@.microsoft.com...
> Is there any way to make dates come out like "11-oct-07"? There does not
> appear to be a built-in format like this. Is there a secret method?
> Maury|||> select replace(convert(varchar(20),getdate(),106),' ','-')
returns: 11-Oct-2007
select replace(convert(varchar,getdate(),6),' ','-')
returns: 11-Oct-07
see 'convert' in BOL.
>
> "Maury Markowitz" <MauryMarkowitz@.discussions.microsoft.com> wrote in
> message news:280EFB54-FE00-4153-A51F-C4D539D8EF12@.microsoft.com...
>> Is there any way to make dates come out like "11-oct-07"? There does not
>> appear to be a built-in format like this. Is there a secret method?
>> Maury
>|||And to get an exact match to the request ...
select lower(replace(convert(varchar,getdate(),6),' ','-'))
returns: 11-oct-07
>> select replace(convert(varchar(20),getdate(),106),' ','-')
> returns: 11-Oct-2007
> select replace(convert(varchar,getdate(),6),' ','-')
> returns: 11-Oct-07
> see 'convert' in BOL.
>>
>> "Maury Markowitz" <MauryMarkowitz@.discussions.microsoft.com> wrote in
>> message news:280EFB54-FE00-4153-A51F-C4D539D8EF12@.microsoft.com...
>> Is there any way to make dates come out like "11-oct-07"? There does not
>> appear to be a built-in format like this. Is there a secret method?
>> Maury
>>
>

Dbf To Ms Sql Server 2000

:eek: HI ALL
I m having my data in DBF file format. now i want to use my .Dbf files Data in to SQL Server 2000. so i can use SQL query on that and extract data from that. i want to use my DBF data in SQL. tell me how it is possible. plz give me soloution ...
Thanx
Manu VermaDo you still have a database server that will read the dbf files? If so, you can connect to it from SQL Server using DTS and import the data.|||Do you still have a database server that will read the dbf files? If so, you can connect to it from SQL Server using DTS and import the data.

we can read DBF files even in Excel or in VFoxpro. tell me the way to Import the data. i tried in SQL Server 2000. I select the Visual Foxpro ODBC Driver it gave the error. How can i import data via using DTS?|||we can read DBF files even in Excel or in VFoxpro. tell me the way to Import the data. i tried in SQL Server 2000. I select the Visual Foxpro ODBC Driver it gave the error. How can i import data via using DTS?

Follow this...
Open EM>Right click on Database>All Tasks>Import data>Select Microsoft Visual Foxpro Driver as data source>Select User/SystemDSN>New>System data source>Visual foxpro driver>Give data source name>Browse the database>Select the created DSN> and you are through...:cool:|||I select the Visual Foxpro ODBC Driver it gave the error.The error? Believe it or not, there are actually several errors you can get. Care to post the message you received?|||Hi,

You might need to download the latest drivers for Foxpro/Dbf.
Thanks

RN|||When i import the data from Foxpro .dbf file to sql, there is error:

Insert error, Column 47 ('mrlvbd',DBType_DBTimeStamp),status 6: Data Overflow.

Then i found out that it might be because of the date field of the data is blank. What can i do to solve this?

Thanks in advance|||I have found the solution.

1 ) In the Select Source Dialog Box,select the Transform Button.

2) Change the Destination Datatype of the related field from SmallDateTime to DateTime

Thanks