General information
Forum:
Microsoft SQL Server
Ashish,
>I hace one database, I want to create same database with no data.
>is there any other way except database script, backup and restore, sp_attachdb >etc.
If you are using SQL7, use the data import export wizard. Select your source and destination and choose transfer objects and data between SQL Server 7.0 Databases.
On the next screen, simply uncheck copy data. This will copy the structures, stored procedures etc.
Hope this helps.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only