Through enterprise manager, there is a generate script tool that will
create scripts for tables, views, sp's, rules, roles ... just about
anything in the database. Do a search for Documenting and Scripting
Databases in BOL and you'll find more.
B

Brian Nordberg
Stockamp Database Administrator
Univerisity Of Utah Hospitals and Clinics
brian.[Email Address Removed] Lonnye Blake Bower <[Email Address Removed] 4/28/2004 12:23:06
PM >>>
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