I've just created an empty database on my machine. I now wish to copy a table from our server database to this local database.
What sql commands do I need to run to do this? I wish to create the new table, copy data from the old table and insert it into the new table.
Create a linked server to the source server. The easiest way is to right click "Linked Servers" in Management Studio; it's under Management -> Server Objects.
Then you can copy the table using a 4-part name,
select * into DbName.dbo.NewTable from LinkedServer.DbName.dbo.OldTable
This will both create the new table with the same structure as the original one and copy the data over.