I have gone through many related SO threads and got some basic info.

Already generated DB diagram.

After that i am unable to find a button/option to generate SQL scripts (create) for all the tables in diagram.

"Generate script" button is disabled, even on clicking the table in diagram.

However i enabled the auto-generate option in tools->designer. But what to do with previous diagrams.

I just want an easy way to auto-generate such scripts (create/alter) and would be gud if i get auto-generated stored procs for insert/selects/update etc.

EDIT: I could do generate scripts for DB objects.

Now: 1. How to import DB diagram from another DB. 2. How to generate (and manage their change integrated with VS source control) routine stored-procs like insert, update and select.

Ok let me ask another way, can experts guide on the usual flow of creating/altering tables (across releases), creating stored-procs (are stored-procs the best way to go ?) and their change-management using SSMS design tools and minimal effort ?