You can use the DTS Import/Export Wizard.
(You will find this Under the menu item Action/All Tasks/Import Data...)
Choose your source and destination... Blah, Blah... Press Next.
Choose Copy Objects... Press next.
Then uncheck the Copy Data box.

Steve S.
[Email Address Removed] 338-1808 x301

-----Original Message-----
From: Lonnye Blake Bower [mailto:[Email Address Removed]
Sent: Wednesday, April 28, 2004 02:23 PM
To: LazyDBA.com Discussion
Subject: Database schema import


Is there a way to import the schema (I need EMPTY TABLES) of one database to
a different server? I see the import metadata, however cannot figure out how
to get the schema to transfer to the new server. Thanks! ~lb

Lonnye Blake Bower
SQL Database Administrator
[Email Address Removed] | 213.739.5327 | www.citysearch.com
<www.citysearch.com>

MS Sql Server LazyDBA home page