how to backup ms sql server database without data

[chennaiprogrammer]

If I want to take a backup of an sql server 2000 database (everything the stored procedure, table definitions etc ..basically everything) EXCEPT the stored data what TRANSACT sql should I use ?

 

[Andel]

what you can do is to generate script for the database. right click on the database, then select "all tasks" then "generate sql scripts". from there, you can select all the objects you want to script or back up. you can then execute the script you generated if you want to recreate the objects.

Andel

http://www.iluko.com