Click here to Skip to main content
14,773,218 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
how to generate Script in sql server 2008 databse,
i want to genereate procedure script if procedure is alter mode then it should be create alter
Posted
Comments
manognya kota 10-Sep-12 2:51am
   
Can you be little more clear please

Have a look:

Pinal Dave: Create Script[^]

MSDN:
How to: Generate Create Scripts[^]
Generate a Script (SQL Server Management Studio)[^]

..and lot more similar threads here[^]
   
Comments
Mohamed Mitwalli 10-Sep-12 3:01am
   
5+
Prasad_Kulkarni 10-Sep-12 3:03am
   
Thank you Mohamed!
__TR__ 10-Sep-12 3:10am
   
+5
Prasad_Kulkarni 10-Sep-12 3:10am
   
Thank you TR!
_Amy 10-Sep-12 3:18am
   
5'ed. :)
Prasad_Kulkarni 10-Sep-12 3:26am
   
Thank you Amit! but where's FIVE ??:)
_Amy 10-Sep-12 3:34am
   
Oh I missed it.. Now given. :)
Hi ,
Right Click on Database name on object explorer select Tasks then Generate Script Click Next Then select the objects you want to Script it or leave it for the whole Database
Next Click on Advanced Choose Script Drop and Create Version of sql select Type of data to script You will find alot options specify what you need then click ok then Choose save to new query then Next Next Finish
http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]
Best Regards
M.Mitwalli
   
Comments
__TR__ 10-Sep-12 3:09am
   
+5
Mohamed Mitwalli 10-Sep-12 3:11am
   
Thanks TR :)
Prasad_Kulkarni 10-Sep-12 3:11am
   
5'ed :D
Mohamed Mitwalli 10-Sep-12 3:11am
   
Thanks Prasad :)
_Amy 10-Sep-12 3:18am
   
5'ed. :)
Mohamed Mitwalli 10-Sep-12 3:40am
   
Thanks Amy :)
Mohamed Mitwalli 10-Sep-12 3:44am
   
it seems i didn't get the points for your voting :( lol
_Amy 10-Sep-12 4:51am
   
oh! Now I have given. :)
Mohamed Mitwalli 10-Sep-12 5:19am
   
Thanks :)
Dev-0001 10-Sep-12 4:10am
   
5
Mohamed Mitwalli 10-Sep-12 4:11am
   
Thanks Dev

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900