If you have access to the database through Query Analyzer, the best way would probably be to load all the data in the existing table into a temp table, then create...

Connecting via hostname using windows authentication.