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 ?
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.