Hello,

Here is code we are searching for contacts.

Thanks,

ARP

Hi.

The datatype for that column Nvarchar(Max)

Thanks

hi,

When i got this error,I ran following queries and DB back.

EXEC sp_resetstatus 'yourDBname';

ALTER DATABASE yourDBname SET EMERGENCY

DBCC checkdb('yourDBname')

ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

DBCC CheckDB ('yourDBname', REPAIR_ALLOW_DATA_LOSS)

ALTER DATABASE yourDBname...

hi,

When i came in the morning one of the db was showing Suspended mode..

after that i have taken care of that.

could you please let me know why we get this...

Are you looking in multiple tables for "abc"?

Or are you looking at multiple rows in the ONE table where the column has a value of "abc"?

Posting scripts to recreate the...

"It sounds like you want to search all columns in all tables in the entire database for occurrences of this value? Is that correct?"

Yes, am looking column value in all...

I have the notepad data with spaces.

I could not import the data into sql Server 2008.

The data:

1000023 ...