How to COPY table/database to another machine

Is it very involved to copy a database from one server to another in a seperate location? Or should I find a MSSQLSERVER forum to post this in?

The short answer to your move question is, not necessarily.
In Enterprise Manager, right-click your database, choose "All Tasks" and then either "Import Data..." or "Export Data..." (depending on what direction you're going).
This opens the "Data Transformation Services" wizard which can do just about everything you need for your move.
Keep in mind you'll need the appropriate SQL Server port accessiable to where your data is going, and recreating Account permissions in the new location may need some extra attention.
Hope that gets you started well enough.|||Create a linked server and then do a normal select against it
insert into newServer.database.dbo.tableName
select * from oldServerTableName

Nick|||I want to copy it to a disk or usb stick, and bring it to a non networked PC( will be networked later). I looked into the export feature in Enterprise mgr. Not sure what to export it to. Am I in the ballpark?|||

How large is your DB? If its not to large, create backups and port those over to the other machine and do a restore. If its large, you might have trouble moving the data around depending on the type of device you are going to use (CDs, DVDs, etc)
Nick

|||It looks like it will not allow me to back it up to a file but it's looking for a device like some tape backup which I do not have). How picky is this thing?
|||Scratch that last post, I got it to work on another drive but it was picky about my initial choice. Does the resultant file have to have a certain extension to be restored?|||

No, the extension is not important. Just ensure you select the correct file when doing the Restore.

|||Thanks a bunch. THREAD CLOSED. ( I hope)