How to Copy tables from one database to another in SQL Server?

Question

Hello Sir I have databases named LMS  Stud . In LMS i have two tables and I want to copy the tables of LMS to Stud. what will be the command.?

Ehtesham · Answer

Script the 'create table' in management studio run that script in bar to create the table. (Right click table in object explorer script table as create to...) INSERT LMS .[schema].table1 SELECT * FROM Stud .[schema].table1

Kunal Vaishya · Answer

Dear In MsSql you can use another database using Link server First Add Link Server and Use It Example sp_addlinkedserver [ @server= ] 'server' [  [ @srvproduct= ] 'product_name' ] [  [ @provider= ] 'provider_name' ] [  [ @datasrc= ] 'data_source' ] [  [ @location= ] 'location' ] [  [ @provstr= ] 'provider_string' ] [  [ @catalog= ] 'catalog' ] try this More references refer this http://www.execsql.com/post/linked-servers-in-sql-server-2005 http://blog.sqlauthority.com/2007/10/06/sql-server-executing-remote-stored-procedure-calling-stored-procedure-on-linked-server/ http://msdn.microsoft.com/en-us/library/ms190479.aspx