Adding new table to production database

Have developed and tested modification to database & web site on my local machine.
Using Microsoft SQL Server Management Studio.
Connected to my test database on my local machine (identified as "mike")
Connected to my database onhosted system sql2k505.discount.asp.net.myhosteddatabase
Trying to copy schema from a new table on test machine to database onhosted system. Ran query:
SELECT * FROM mike.mydatabase.dbo.SessionLog INTO dbo.SessionLog IN sql2k505.discountasp.net.myhosteddatabase;
Get error "Incorrect syntax near the keyword 'INTO'."
Syntax looks correct according to all sources I can find. Can you assist?

Thanks.

 

You've got a mixture of SQL there, parts will work but not in one query like that.
If you want to copy the data use the Import/Export table tools.
You can do it from either the local or remote DB, just right-click to get the Table options.