Deadlocks occur at the resource level. It may be deadlocking on pages within the table.

Try the below steps to find out what is the other process in the deadlock.

what does the contents of the xmlconfig file look like?

Are you trying to add a xml config file or edit one?

If when the database was deleted you told it not to delete the backup history you may be able to use....

use msdb

go

select bs.database_name,bmf.physical_device_name from backupmediafamily bmf

join backupset bs on (bs.media_set_id=bmf.media_set_id)

order...

Try looking at the BCP command line utility. This will allow you export data into a text file.

Quotes from book online.

Clustered Index

Primary Key

A primary key constraint ensures no duplicate values are entered in particular columns and...

--Here is a schema friendly version.

---------------------------------

declare @cmd nvarchar(4000)

declare @srchstr nvarchar(200)

declare @tbl nvarchar(255)

declare @col nvarchar(255)

create table ##results (res varchar(255))

select @srchstr='ALFKI' --CHANGE THIS TO YOUR SEARCH STRING

declare structure cursor for

select table_schema+'.['+table_name+']',column_name from...

Not sure.

if you were to write the sql statement yourself with a where clause would you use a like or =

is it nchar,char,nvarchar or varchar value?

It could also be the column.

It prints the command in the messages window try copying one of the erroring strings to the query and see what happens.

Try the below...

This will take a while as it searches every char, nchar, nvarchar & varchar column.

-------------

declare @cmd nvarchar(4000)

declare @srchstr nvarchar(200)

declare @tbl nvarchar(255)

declare @col nvarchar(255)

create table ##results (res varchar(255))

select @srchstr='ALFKI'...

The sample data you have been given. Is it an exact match (=) or partial (like).

Also what is the size of the database you want to search?

Have updated the script so that it works for identity and with money data type. It is awaiting approval.

But here is the new one.

Let me know if you have any...

If it is a problem inserting into an identity field try using...

SET IDENTITY_INSERT TABLENAME ON

Though you will need to turn it back off again.

If thats not the problem let me...