i have one table 'user' in database 'mainUser2011' the table is bellow
userId Username
---------------------
1 Asok
2 kishan
userId :- is autoincrement(Identity is on) and primary key
Username :- is nvarchar(50)
and the same table 'user' in database mainUser2010
i want to copy the contenet of database in mainUser2011 to database mainUser2010 the curesponding table
Loading

Sam HobbsPosted Mar 11, 2011, 11:03 PM
If Krishna's reply does not help you then you should have replied in that thread instead of creating a new one.