ok here is the code and i didn't use stored procedure .it is just an sql statement calling it from C#

select *

from " + old + ".dbo.table1 

left outer...

first really 10x alot for ur help,

then, old is a variable that hold database name which the user will choose before begining copying data  , and new is a variable...

can't i make something from database to specify collation for all new created databases and all old databases to be the same coz as i told u that old and...

select *

from old.dbo.table1  left outer join

new.dbo.table2 on new.dbo.table2.id=old.dbo.table1.id

this is my SQL statement whil error is:

"Cannot resolve collation conflict for equal to operation"

10x for ur reply and second yes am using join but the database am copying data to it am creating it at run time and the database am copying from...