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

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

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