A. Fire up SQL Enterprise Manager. Right-click on the database you want to script. Choose All Tasks. Choose Generate SQL Scripts. You will then choose which objects (or all of them) you want to script from there.