I have Two databases in my SqlServer 2005.
For Example : I have Database(SchoolDB) and another Database(CollegeDB)
Now From these Two DATABASES I need to make One Database.....OK.
My requirement is : In CollegeDB i have two Tables StudentInformation and TeachersInformation. So i have to copy these two tables to SchoolDB Database with all the data in it.
Please can anybody help me, how to do this.
THANKS FOR EVER.