help! trying to find records inside text string

Hi, got a problem and can't figure this one out.

basically i've got a field containing a value '(14)(12)(33)(22)' and i want to compare it to a table containing those values in separate cells...

record 1 : (01)
record 2 : (02)
etc...

and i want to compare this one field to those records to see whether that text string contains anything the table contains.

i've tried ContainsTable & IN but still can't figure this out.

any help greatly appreciated
:owould you kindly give us the table names and column names involved

otherwise the most i can tell you is to use LIKE

HELP! full text catalogs disapearing!

I have one publisher that pushes out a database to two subscribers, each with
Win 2003 server and SQL 2000 sp3. This Db has two tables who each have one
column full text indexed. The publisher is full text indexed so that QA can
test the data before replication happens.
my problem is that after the replication finishes sync'ing up the
subscribers, My tables are no longer full text enabled and my catalogue
disappears.
Can someone tell me how to avoid this? It takes about 5 ours to drop and
rebuild the catalog.
Thank you in advance!
Carl,
Unfortunately SQL Server 2000 FT Catalogs are not directly supported with
Replication. The one-time snapshot of your table does not re-create the FT
Catalog parameter for the FT-enable table and once the table is created on
your subscriber, you will need to manually re-create the FT Catalog and set
Change Tracking with Update Index in Background and this will run a Full
Population (if the FT Catalog is un-populated).
Could you provide more details on how your subscribers tables are setup?
Thanks,
John
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:B94E5A44-0594-4378-A272-0E8280935B3F@.microsoft.com...
> I have one publisher that pushes out a database to two subscribers, each
with
> Win 2003 server and SQL 2000 sp3. This Db has two tables who each have one
> column full text indexed. The publisher is full text indexed so that QA
can
> test the data before replication happens.
> my problem is that after the replication finishes sync'ing up the
> subscribers, My tables are no longer full text enabled and my catalogue
> disappears.
> Can someone tell me how to avoid this? It takes about 5 ours to drop and
> rebuild the catalog.
> Thank you in advance!
|||I am using transactional replication to push the changes from my publisher to
the subscribers. Here is the schema for one subscriber/publisher table:
CREATE TABLE defdba (
UID bigint NOT NULL CONSTRAINT MSrepl_synctran_identity_default_1525580473
DEFAULT (0),
NAME varchar(256) NULL ,
DBAID int NULL ,
JUDGEMENTID int NULL ,
MERLINNAME varchar(300) NULL ,
ADDDATE varchar(8) NOT NULL ,
msrepl_tran_version uniqueidentifier NOT NULL CONSTRAINT
DF__defdba__msrepl_t__5C37ACAD DEFAULT (newid()),
CONSTRAINT PK_defdba PRIMARY KEY CLUSTERED
(
UID
) ON PRIMARY
)
I had set up the FTI to check for changes in the background, and then update
itself when replication push the data changes accross to the subscriber. From
what I am hearing you say, after I replicate the changes over, I must rebuild
the catalog from scratch each time. Is that correct?
"John Kane" wrote:

> Carl,
> Unfortunately SQL Server 2000 FT Catalogs are not directly supported with
> Replication. The one-time snapshot of your table does not re-create the FT
> Catalog parameter for the FT-enable table and once the table is created on
> your subscriber, you will need to manually re-create the FT Catalog and set
> Change Tracking with Update Index in Background and this will run a Full
> Population (if the FT Catalog is un-populated).
> Could you provide more details on how your subscribers tables are setup?
> Thanks,
> John
>
> "Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
> news:B94E5A44-0594-4378-A272-0E8280935B3F@.microsoft.com...
> with
> can
>
>
|||Carl,
No, it's the initial snapshot that is the problem as when the table schema
is created the on the subscribers, the FT Catalogs parameters (FT Catalog
name, FT-enabled columns) are not created and Change Tracking and Update
Index in background is not defined. Assuming that you do the snapshot only
once you will have to re-create this metadata only once, but when ever you
schedule another snapshot, you will have to re-do the FT Catalog metadata.
This may be the source of why your FT Catalogs are disappearing!
Furthermore, depending upon the amount (number of rows) and frequency
(batch/second or batch/hour), you should be able to use "Change Tracking"
and "Update Index in Background" on the Push Subscribers.
Regards,
John
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:ECE0559F-C45A-4F14-A84F-9F5753BD1B1F@.microsoft.com...
> I am using transactional replication to push the changes from my publisher
to
> the subscribers. Here is the schema for one subscriber/publisher table:
> CREATE TABLE defdba (
> UID bigint NOT NULL CONSTRAINT MSrepl_synctran_identity_default_1525580473
> DEFAULT (0),
> NAME varchar(256) NULL ,
> DBAID int NULL ,
> JUDGEMENTID int NULL ,
> MERLINNAME varchar(300) NULL ,
> ADDDATE varchar(8) NOT NULL ,
> msrepl_tran_version uniqueidentifier NOT NULL CONSTRAINT
> DF__defdba__msrepl_t__5C37ACAD DEFAULT (newid()),
> CONSTRAINT PK_defdba PRIMARY KEY CLUSTERED
> (
> UID
> ) ON PRIMARY
> )
> I had set up the FTI to check for changes in the background, and then
update
> itself when replication push the data changes accross to the subscriber.
From
> what I am hearing you say, after I replicate the changes over, I must
rebuild[vbcol=seagreen]
> the catalog from scratch each time. Is that correct?
> "John Kane" wrote:
with[vbcol=seagreen]
FT[vbcol=seagreen]
on[vbcol=seagreen]
set[vbcol=seagreen]
message[vbcol=seagreen]
each[vbcol=seagreen]
one[vbcol=seagreen]
QA[vbcol=seagreen]
catalogue[vbcol=seagreen]
and[vbcol=seagreen]
|||I think your problem is with the way replication modifies tables for
replication.
It looks like you are complaining about the dropping of the full text
indexing on your publisher, correct? I think this is a consequence of using
queued updating which does modify both the publisher and the subscriber
tables.
I am curious as to why you are using queued? You might be able to get away
with using pure bi-directional transactional replication, depending on
certain factors.
Can you tell me exactly what you are trying to do, where do most of your
updates happen and how many subscribers you have? Also have you implemented
any partitioning scheme to avoid conflicts?
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:B94E5A44-0594-4378-A272-0E8280935B3F@.microsoft.com...
>I have one publisher that pushes out a database to two subscribers, each
>with
> Win 2003 server and SQL 2000 sp3. This Db has two tables who each have one
> column full text indexed. The publisher is full text indexed so that QA
> can
> test the data before replication happens.
> my problem is that after the replication finishes sync'ing up the
> subscribers, My tables are no longer full text enabled and my catalogue
> disappears.
> Can someone tell me how to avoid this? It takes about 5 ours to drop and
> rebuild the catalog.
> Thank you in advance!
|||Hilary, thank you for your help!!!
My publisher server is where I process incoming raw files to update my
delivery servers (subscribers). There are six tables, two of which have one
column (MerlinName) that are FTI-enabled. Each table has between 4-6 million
rows in them.
I have Transactional Replication running once a week (The Publisher is only
updated 1-3 times a week.), and I rebuild the catalog three hours later in a
sql agent job. I rebuild that catalog each time because that only takes about
5 hours, where incremental rebuild can take up to 12 hours. I can run the sql
agent job seperately and it works fine.
Here is the sql agent job code:
EXEC sp_fulltext_catalog @.ftcat = 'db_cat', @.action = 'Rebuild'
EXEC sp_fulltext_catalog @.ftcat = 'db_cat', @.action = 'Start_Full'
When I come back the next day, the Subscribers data is sync'ed, but all FTI
configurations are gone. There is a catalog, but it is empty.
I dont understand how a transactional replication, which is just adding rows
to a table, can remove the FTI configurations.
"Hilary Cotter" wrote:

> I think your problem is with the way replication modifies tables for
> replication.
> It looks like you are complaining about the dropping of the full text
> indexing on your publisher, correct? I think this is a consequence of using
> queued updating which does modify both the publisher and the subscriber
> tables.
> I am curious as to why you are using queued? You might be able to get away
> with using pure bi-directional transactional replication, depending on
> certain factors.
> Can you tell me exactly what you are trying to do, where do most of your
> updates happen and how many subscribers you have? Also have you implemented
> any partitioning scheme to avoid conflicts?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
> "Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
> news:B94E5A44-0594-4378-A272-0E8280935B3F@.microsoft.com...
>
>
|||Were you able to find out anything about this?
"Hilary Cotter" wrote:

> I think your problem is with the way replication modifies tables for
> replication.
> It looks like you are complaining about the dropping of the full text
> indexing on your publisher, correct? I think this is a consequence of using
> queued updating which does modify both the publisher and the subscriber
> tables.
> I am curious as to why you are using queued? You might be able to get away
> with using pure bi-directional transactional replication, depending on
> certain factors.
> Can you tell me exactly what you are trying to do, where do most of your
> updates happen and how many subscribers you have? Also have you implemented
> any partitioning scheme to avoid conflicts?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> Now available for purchase at:
> http://www.nwsu.com/0974973602.html
> "Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
> news:B94E5A44-0594-4378-A272-0E8280935B3F@.microsoft.com...
>
>
|||Carl,
As I said in my initial posting SQL Server 2000 FT Catalogs are not directly
supported with Replication. So, the replication of textual data & objects
(views, functions etc) containing full-text predicates such as CONTAINS* or
FREETEXT* during the initial snapshot is not supported. However, a
workaround is to manually create and maintain a post-snapshot script that
contains the FTS code as well as the referenced full-text indexes should be
placed in a post-snapshot script instead of being published as articles. You
can setup a SQLServerAgent job step to do this automatically and for some
T-SQL script examples , see KB article 240867 (Q240867) "INF: How to Move,
Copy, and Backup Full-Text Catalog Folders and Files" at
http://support.microsoft.com/default...b;EN-US;240867
Regards,
John
"Carl Henthorn" <CarlHenthorn@.discussions.microsoft.com> wrote in message
news:2CC14822-F27F-44ED-9046-5C72714A8D79@.microsoft.com...[vbcol=seagreen]
> Were you able to find out anything about this?
> "Hilary Cotter" wrote:
using[vbcol=seagreen]
away[vbcol=seagreen]
implemented[vbcol=seagreen]
message[vbcol=seagreen]
each[vbcol=seagreen]
one[vbcol=seagreen]
QA[vbcol=seagreen]
catalogue[vbcol=seagreen]
and[vbcol=seagreen]

Help! - BCP / Bulk Copy

I need top update several tables with new values from an external text file. That would notrmally be a no brainer, (even for me) :) But, what is important this time around, is I can NOT fire the triggers, or every user would get notified of a 150,000 updates.

The text file contains 4 fields
KEYNUM|UpdateField1|UpdateField2|Class

Class will be either 1 or 2, if class = 1 then table 1 contains the record, if class = 2 then table 2 contains the record...

Any help, as always is greatly appreciatedHi,

By default BCP does not fire triggers, it will only fire triggers if you use the FIRE_TRIGGERS hint.

Does that change anything or help?|||Originally posted by bmalar
Hi,

By default BCP does not fire triggers, it will only fire triggers if you use the FIRE_TRIGGERS hint.

Does that change anything or help?

That Part I knew (but thanks). How can I use bcp to update selected records? (i.e. update records based on values in the KEYNUM field)|||Originally posted by GregCrossan
That Part I knew (but thanks). How can I use bcp to update selected records? (i.e. update records based on values in the KEYNUM field)

Sorry I didn't read your post correctly.. I thought you were inserting new records.

Help with xp_sendmail needed!

This is a multi-part message in MIME format.
--=_NextPart_000_0006_01C4F641.316CAF50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello,
I am using xp_sendmail SP to send emails to myself, not to a = distribution list. I receive the error: Server: Msg 18031, Level 16, = State 1, Line 0
xp_sendmail: Could not resolve recipient
The server is a MS Windows 2003 running SQL 2000 and Office XP SP3. The = OS, SQL and Office are fully updated. I do not think that this problem = is related to the bug described in Article ID:315666.
May I ask you for some help?
Thank you,
Ovidiu Tanjala
--=_NextPart_000_0006_01C4F641.316CAF50
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hello,
I am using xp_sendmail SP to send emails = to myself, not to a distribution list. I receive the error: Server: Msg 18031, = Level 16, State 1, Line 0
xp_sendmail: Could not resolve = recipient
The server is a MS Windows 2003 running = SQL 2000 and Office XP SP3. The OS, SQL and Office are fully updated. I do not think = that this problem is related to the bug described in Article = ID:315666.
May I ask you for some help?
Thank you,
Ovidiu Tanjala =
--=_NextPart_000_0006_01C4F641.316CAF50--Hi Ovidiu,
Are you able to execute xp_stopmail and xp_startmail successfully? Also
please post your xp_sendmail statement, which resulted in this error.
--
Thanks
Yogish

Help with writing sql statement

I need some help writing a query. I have a text file that will be imported on a weekly basis, with 1000+ rows and 5 columns. This i need to import into table tblECR which i have added 2 of my own columns.

The problem is the text file will arrive with current data and new data. The current data may or may not have changed (dates, status etc). How do i go about importing the new data and updating the existing data with the new fields, without deleting the data in the 2 columns i've added. I'm using vs 2005 with a sql 2005 express database.

This is the code i'm using to import the data currently. Clicking the button more than once will obviously just import all the data into the database again.

Private Sub CustomerDataToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CustomerDataToolStripMenuItem.Click

'Clear the dataset

dsimport.Clear()

'Set the file variables

Dim strFileName As String

Dim strFilePath As String

Dim sSlash As Single

'Open the file dialog and select the text file to open

Try

With OpenFileDialog1

'Set the initial dialog options

.Title = "Import Customer data file"

.InitialDirectory = "P:\Ian\"

.FileName = ""

.Filter = "File (*.csv)|*.csv|All files (*.*)|*.*"

If OpenFileDialog1.ShowDialog() <> Windows.Forms.DialogResult.Cancel Then

Else

MessageBox.Show("No file was selected", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information)

Exit Sub

End If

'Strip the filename into its seperate portions

sSlash = InStrRev(.FileName, "\")

strFilePath = Mid(.FileName, 1, CInt(sSlash))

strFileName = Mid(.FileName, CInt(sSlash + 1), Len(.FileName))

End With

'Set the connection properties to read the text file

Dim strConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & strFilePath & ";" & "Extended Properties=""text;HDR=NO;FMT=Delimited"""

Dim conn As New OleDb.OleDbConnection(strConnectionString)

'Open connection with the database.

conn.Open()

'Create new OleDbCommand to return data from the text file

Dim objCmdSelect As New OleDb.OleDbCommand("SELECT * FROM [" & strFileName & "]", conn)

' Create new OleDbDataAdapter that is used to build a DataSet based on the preceding SQL SELECT statement

Dim objAdapter1 As New OleDb.OleDbDataAdapter

'Pass the Select command to the adapter

objAdapter1.SelectCommand = objCmdSelect

'Fill the DataSet with the information from the file

objAdapter1.Fill(dsimport, "Import")

objAdapter1.AcceptChangesDuringFill = False

'Clean up objects

conn.Close()

Catch ex As Exception

MsgBox(ex.Message).ToString()

Exit Sub

End Try

'Now import the data into the table

Dim sqlcn As New SqlConnection(ConnString)

Dim sqlcmd_ECR As New SqlCommand

Dim dr As DataRow

Try

sqlcn.Open()

'Setup the sql command to enter data into the ECR table

sqlcmd_ECR.Connection = sqlcn

sqlcmd_ECR.CommandText = "Insert into tblECR_Test(ECR_No,Aims_No,ECR_Type) Values(@.a,@.b,@.c)"

'Setup the sql parameters to enter data into the ECR table

sqlcmd_ECR.Parameters.Add("@.a", SqlDbType.Int)

sqlcmd_ECR.Parameters.Add("@.b", SqlDbType.Int)

sqlcmd_ECR.Parameters.Add("@.c", SqlDbType.VarChar, 255)

Try

For Each dr In dsimport.Tables(0).Rows

sqlcmd_ECR.Parameters("@.a").Value = dr(0)

sqlcmd_ECR.Parameters("@.b").Value = dr(1)

sqlcmd_ECR.Parameters("@.c").Value = dr(2).ToString()

sqlcmd_ECR.ExecuteNonQuery()

Next

Catch ex1 As SqlException

MsgBox(ex1.Message).ToString()

Exit Sub

End Try

MessageBox.Show("The text file was successfully imported.", "Customer data import", MessageBoxButtons.OK, MessageBoxIcon.Information)

Catch ex3 As Exception

MsgBox(ex3.Message).ToString()

End Try

sqlcn.Close()

End Sub

ExecuteNonQuery returns an integer that tells you how many rows were affected by the query, so you could run an update first (trying to update the record assuming it is already there) and then if the rows affected is 0 instead of 1, run the insert.

help with unusual victum messages

This is a multi-part message in MIME format.
--=_NextPart_000_0058_01C43F8A.9695C150
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I am finding some unusual deadlock victum messages in my errorlogs that = I have included in this message. I would appreciate any information = about these messages. I am familiar with the normal deadlock message, = it is the statements in red that I need help with.
thanks
tim
2004-05-21 16:07:58.18 spid4 Deadlock encountered ... Printing deadlock information
2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 Wait-for graph
2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 Node:1
2004-05-21 16:07:58.18 spid4 RID: 5:1:536178:4 = CleanCnt:1 Mode: X Flags: 0x2
2004-05-21 16:07:58.18 spid4 Grant List 3::
2004-05-21 16:07:58.18 spid4 Owner:0x68e15860 Mode: X = Flg:0x0 Ref:0 Life:02000000 SPID:54 ECID:0
2004-05-21 16:07:58.18 spid4 SPID: 54 ECID: 0 Statement Type: = UPDATE Line #: 2
2004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: = dbo.NEXTKEYZZZbIGIp$7;1
2004-05-21 16:07:58.18 spid4 Requested By: 2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U = SPID:51 ECID:0 Ec:(0x7DD3D9B0) Value:0x705729e0 Cost:(0/0)
2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 Node:2
2004-05-21 16:07:58.18 spid4 KEY: 5:1685581043:2 (6401bf0349e3) = CleanCnt:1 Mode: U Flags: 0x0
2004-05-21 16:07:58.18 spid4 Grant List 2::
2004-05-21 16:07:58.18 spid4 Owner:0x70573a40 Mode: U = Flg:0x0 Ref:1 Life:00000000 SPID:51 ECID:0
2004-05-21 16:07:58.18 spid4 SPID: 51 ECID: 0 Statement Type: = UPDATE Line #: 2
2004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: = dbo.NEXTKEYZZZbIGIp$7;1
2004-05-21 16:07:58.18 spid4 Requested By: 2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U = SPID:54 ECID:0 Ec:(0x7A6B59B0) Value:0x79f4cac0 Cost:(0/148)
2004-05-21 16:07:58.18 spid4 Victim Resource Owner:
2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U = SPID:51 ECID:0 Ec:(0x7DD3D9B0) Value:0x705729e0 Cost:(0/0)
2004-05-21 16:11:50.78 spid4 Victim Resource Owner:
2004-05-21 16:11:50.78 spid4 ResType:ExchangeId Stype:'AND' SPID:69 = ECID:22 Ec:(0x75A58098) Value:0x800f3988 Cost:(0/2710)
2004-05-21 16:11:55.78 spid4 Victim Resource Owner:
2004-05-21 16:11:55.78 spid4 ResType:ExchangeId Stype:'AND' SPID:69 = ECID:22 Ec:(0x75A58098) Value:0x800f3988 Cost:(0/2710)
--=_NextPart_000_0058_01C43F8A.9695C150
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
I am finding some unusual deadlock = victum messages in my errorlogs that I have included in this message. I would = appreciate any information about these messages. I am familiar with the = normal deadlock message, it is the statements in red that I need help with.

thanks

tim

2004-05-21 16:07:58.18 spid4 Deadlock encountered ... Printing = deadlock information2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 Wait-for graph2004-05-21 16:07:58.18 spid4 = 2004-05-21 16:07:58.18 spid4 Node:12004-05-21 = 16:07:58.18 spid4 RID: 5:1:536178:4 &= nbsp; CleanCnt:1 Mode: X Flags: 0x22004-05-21 16:07:58.18 spid4 Grant List 3::2004-05-21 = 16:07:58.18 spid4 Owner:0x68e15860 Mode: X Flg:0x0 Ref:0 Life:02000000 = SPID:54 ECID:02004-05-21 16:07:58.18 = spid4 SPID: 54 ECID: 0 Statement Type: UPDATE Line #: 22004-05-21 = 16:07:58.18 spid4 Input Buf: RPC Event: dbo.NEXTKEYZZZbIGIp$7;12004-05-21 16:07:58.18 spid4 Requested By: 2004-05-21 = 16:07:58.18 spid4 ResType:LockOwner = Stype:'OR' Mode: U SPID:51 ECID:0 Ec:(0x7DD3D9B0) Value:0x705729e0 = Cost:(0/0)2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 Node:22004-05-21 16:07:58.18 spid4 KEY: 5:1685581043:2 (6401bf0349e3) = CleanCnt:1 Mode: U Flags: 0x02004-05-21 16:07:58.18 = spid4 Grant List 2::2004-05-21 16:07:58.18 spid4 Owner:0x70573a40 Mode: U Flg:0x0 Ref:1 Life:00000000 = SPID:51 ECID:02004-05-21 16:07:58.18 = spid4 SPID: 51 ECID: 0 Statement Type: UPDATE Line #: 22004-05-21 = 16:07:58.18 spid4 Input Buf: RPC Event: dbo.NEXTKEYZZZbIGIp$7;12004-05-21 16:07:58.18 spid4 Requested By: 2004-05-21 = 16:07:58.18 spid4 ResType:LockOwner = Stype:'OR' Mode: U SPID:54 ECID:0 Ec:(0x7A6B59B0) Value:0x79f4cac0 Cost:(0/148)2004-05-21 16:07:58.18 spid4 = Victim Resource Owner:2004-05-21 16:07:58.18 = spid4 ResType:LockOwner Stype:'OR' Mode: U SPID:51 ECID:0 Ec:(0x7DD3D9B0) Value:0x705729e0 Cost:(0/0)2004-05-21 = 16:11:50.78 spid4 Victim Resource Owner:2004-05-21 = 16:11:50.78 spid4 ResType:ExchangeId Stype:'AND' = SPID:69 ECID:22 Ec:(0x75A58098) Value:0x800f3988 Cost:(0/2710)2004-05-21 = 16:11:55.78 spid4 Victim Resource Owner:2004-05-21 = 16:11:55.78 spid4 ResType:ExchangeId Stype:'AND' = SPID:69 ECID:22 Ec:(0x75A58098) Value:0x800f3988 Cost:(0/2710)
--=_NextPart_000_0058_01C43F8A.9695C150--This is a multi-part message in MIME format.
--=_NextPart_000_001F_01C44196.C17DBF40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi
Looks like you may have trace flag 1204 set?
http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/trblsq=
l/tr_servdatabse_5xrn.asp
http://msdn.microsoft.com/library/default.asp?url=3D/library/en-us/trblsq=
l/tr_servdatabse_8v5f.asp
John
"Tim Graham" <tgraham3@.metlife.com> wrote in message =news:OtlW4R7PEHA.2704@.TK2MSFTNGP10.phx.gbl...
I am finding some unusual deadlock victum messages in my errorlogs =that I have included in this message. I would appreciate any =information about these messages. I am familiar with the normal =deadlock message, it is the statements in red that I need help with.
thanks
tim
2004-05-21 16:07:58.18 spid4 Deadlock encountered ... Printing deadlock information
2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 Wait-for graph
2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 Node:1
2004-05-21 16:07:58.18 spid4 RID: 5:1:536178:4 =CleanCnt:1 Mode: X Flags: 0x2
2004-05-21 16:07:58.18 spid4 Grant List 3::
2004-05-21 16:07:58.18 spid4 Owner:0x68e15860 Mode: X =Flg:0x0 Ref:0 Life:02000000 SPID:54 ECID:0
2004-05-21 16:07:58.18 spid4 SPID: 54 ECID: 0 Statement Type: =UPDATE Line #: 2
2004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: =dbo.NEXTKEYZZZbIGIp$7;1
2004-05-21 16:07:58.18 spid4 Requested By: 2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: =U SPID:51 ECID:0 Ec:(0x7DD3D9B0) Value:0x705729e0 Cost:(0/0)
2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 Node:2
2004-05-21 16:07:58.18 spid4 KEY: 5:1685581043:2 (6401bf0349e3) =CleanCnt:1 Mode: U Flags: 0x0
2004-05-21 16:07:58.18 spid4 Grant List 2::
2004-05-21 16:07:58.18 spid4 Owner:0x70573a40 Mode: U =Flg:0x0 Ref:1 Life:00000000 SPID:51 ECID:0
2004-05-21 16:07:58.18 spid4 SPID: 51 ECID: 0 Statement Type: =UPDATE Line #: 2
2004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: =dbo.NEXTKEYZZZbIGIp$7;1
2004-05-21 16:07:58.18 spid4 Requested By: 2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: =U SPID:54 ECID:0 Ec:(0x7A6B59B0) Value:0x79f4cac0 Cost:(0/148)
2004-05-21 16:07:58.18 spid4 Victim Resource Owner:
2004-05-21 16:07:58.18 spid4 ResType:LockOwner Stype:'OR' Mode: U =SPID:51 ECID:0 Ec:(0x7DD3D9B0) Value:0x705729e0 Cost:(0/0)
2004-05-21 16:11:50.78 spid4 Victim Resource Owner:
2004-05-21 16:11:50.78 spid4 ResType:ExchangeId Stype:'AND' =SPID:69 ECID:22 Ec:(0x75A58098) Value:0x800f3988 Cost:(0/2710)
2004-05-21 16:11:55.78 spid4 Victim Resource Owner:
2004-05-21 16:11:55.78 spid4 ResType:ExchangeId Stype:'AND' =SPID:69 ECID:22 Ec:(0x75A58098) Value:0x800f3988 Cost:(0/2710)
--=_NextPart_000_001F_01C44196.C17DBF40
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Hi
Looks like you may have trace flag =1204 set?
http://msdn.microsoft.com/library/defa=ult.asp?url=3D/library/en-us/trblsql/tr_servdatabse_5xrn.asp
http://msdn.microsoft.com/library/defa=ult.asp?url=3D/library/en-us/trblsql/tr_servdatabse_8v5f.asp
John
"Tim Graham" =wrote in message news:OtlW4R7PEHA.2704=@.TK2MSFTNGP10.phx.gbl...
I am finding some unusual deadlock =victum messages in my errorlogs that I have included in this message. I =would appreciate any information about these messages. I am familiar =with the normal deadlock message, it is the statements in red that I need help with.

thanks

tim

2004-05-21 16:07:58.18 spid4 Deadlock encountered ... Printing =deadlock information2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 Wait-for graph2004-05-21 16:07:58.18 spid4 =2004-05-21 16:07:58.18 spid4 Node:12004-05-21 =16:07:58.18 spid4 RID: =5:1:536178:4 &=nbsp; CleanCnt:1 Mode: X Flags: 0x22004-05-21 16:07:58.18 spid4 Grant List 3::2004-05-21 =16:07:58.18 spid4 Owner:0x68e15860 Mode: = X Flg:0x0 Ref:0 =Life:02000000 SPID:54 ECID:02004-05-21 16:07:58.18 spid4 SPID: 54 ECID: 0 =Statement Type: UPDATE Line #: 22004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: dbo.NEXTKEYZZZbIGIp$7;12004-05-21 16:07:58.18 spid4 Requested By: 2004-05-21 =16:07:58.18 spid4 ResType:LockOwner =Stype:'OR' Mode: U SPID:51 ECID:0 Ec:(0x7DD3D9B0) Value:0x705729e0 Cost:(0/0)2004-05-21 16:07:58.18 spid4 2004-05-21 16:07:58.18 spid4 =Node:22004-05-21 16:07:58.18 spid4 KEY: 5:1685581043:2 =(6401bf0349e3) CleanCnt:1 Mode: U Flags: 0x02004-05-21 16:07:58.18 spid4 Grant List 2::2004-05-21 =16:07:58.18 spid4 Owner:0x70573a40 Mode: = U Flg:0x0 Ref:1 =Life:00000000 SPID:51 ECID:02004-05-21 16:07:58.18 spid4 SPID: 51 ECID: 0 =Statement Type: UPDATE Line #: 22004-05-21 16:07:58.18 spid4 Input Buf: RPC Event: dbo.NEXTKEYZZZbIGIp$7;12004-05-21 16:07:58.18 spid4 Requested By: 2004-05-21 =16:07:58.18 spid4 ResType:LockOwner =Stype:'OR' Mode: U SPID:54 ECID:0 Ec:(0x7A6B59B0) Value:0x79f4cac0 Cost:(0/148)2004-05-21 16:07:58.18 spid4 =Victim Resource Owner:2004-05-21 16:07:58.18 =spid4 ResType:LockOwner Stype:'OR' Mode: U SPID:51 ECID:0 Ec:(0x7DD3D9B0) Value:0x705729e0 Cost:(0/0)2004-05-21 =16:11:50.78 spid4 Victim Resource Owner:2004-05-21 =16:11:50.78 spid4 ResType:ExchangeId Stype:'AND' =SPID:69 ECID:22 Ec:(0x75A58098) Value:0x800f3988 Cost:(0/2710)2004-05-21 16:11:55.78 spid4 Victim Resource =Owner:2004-05-21 16:11:55.78 spid4 ResType:ExchangeId =Stype:'AND' SPID:69 ECID:22 Ec:(0x75A58098) Value:0x800f3988 Cost:(0/2710)

---

--=_NextPart_000_001F_01C44196.C17DBF40--