I am sorry but i did not understand "PS:- dont tell me you know the exact name as well"

I want to do it with a script

thanks

DDL loggin was not created, and i cannot even restore a previous version. i do have a database is a diff server that has a backup copy of the database...

Sorry it is a numeric field,

Thanks it worked like a charm

i want to do this for a user value so it is necessary, i want to change from ncahr to nvarchar which should be essentially the same right?

Thanks that works and is much more effective than my approach

thanks again

what i am actually trying to do is

update a table X from a different table Y which has multiple records with the same ID i.e.

Table y

Id ...

Thanks that worked, thanks again

Thanks that solved the problem

I simply had to add the statement CAST and convert the datatype into nvarchar and it did the trick

update Time

where earlyLate = 'the earliest time this can be completed...

the script compares all the databases can i compare just two when i tried to replace the scripts as

SELECT AREA FROM [dbo.A]

EXCEPT

SELECT AREA FROM [dbo.B]

I get an error as...

I am sorry i should have had more details. I was trying to compare data and columns in two DB's where all the tables are identical but some tables...

thanks Rich

concatenation seems to be my only option as full text indexing is not set up on the DB where i am trying to use contains

is there any...

A and X

Table A

1ID 1Name X_diff_ID 1active

1 B C2 yes

2 F G2 yes

Table X

XID XName X_diff_ID 1ID 1active

1 B C2 empty yes

2 F G2 empty yes

So i tried...