Script for create & drop database

Posted by Nishithraj under Sql Server on 1/26/2010 | Views : 4517 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

How do we create the scripts of a database(create database , Drop to as in SSMS) using a query? Sp_helptext works for stored procs but not for database.

I need to create sql file after generating the scripts..

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Rtpharry on: 1/26/2010 [Member] [MVP] Bronze

0	You can create these scripts within SSMS by right clicking on a database and choosing Tasks \| Generate Scripts. Most windows in the SSMS have a toolbar along the top that lets you script out the current window. This turns whatever dialog settings you have configured into a sql script. Unfortunately the Generate Scripts window doesn't have this feature. I did find some discussion of third party tools in this thread: http://stackoverflow.com/questions/1695738/programmatically-generate-script-for-all-objects-in-a-database There is something called SMO which lets you access the technology behind the Generate Scripts window. I think this would be your best bet: http://www.mssqltips.com/tip.asp?tip=1833 Nishithraj, if this helps please login to Mark As Answer. \| Alert Moderator

You can create these scripts within SSMS by right clicking on a database and choosing Tasks | Generate Scripts.

Most windows in the SSMS have a toolbar along the top that lets you script out the current window. This turns whatever dialog settings you have configured into a sql script.

Unfortunately the Generate Scripts window doesn't have this feature.

I did find some discussion of third party tools in this thread:

http://stackoverflow.com/questions/1695738/programmatically-generate-script-for-all-objects-in-a-database

There is something called SMO which lets you access the technology behind the Generate Scripts window. I think this would be your best bet:

http://www.mssqltips.com/tip.asp?tip=1833

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts