Vishal,

You can prefix a table name with the name of the database to access tables from a database. Something like this:

INSERT INTO [sgsmech].[dbo].[ryburn]
           ([Col1]
           ,[Col2]
           ,[Col3]
           ,[Col4])
 (select a.Col1, a.Col2, a.Col3, a.Col4 from mech2010.dbo.ryburn a where ...)

>i hav two separate sqlexpress 2005 database naming mech2010 and sgsmech both hav same tables and relations and all
>
>i want copy few records from mech2010 database table rybum and want insert data into the table of rybum in another
>table in other database sgsmech any one can pls tel the query to me.......
>
>Thank You in Advance