I want to retrieve a script for a database that will include operations of creating database, creating tables, and insert all data. How can I achieve this using management studio 2008 please.
I have tried the generate script option , but that seems to create only table structure, doesn't create database or doesn't insert data either.
Either