Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
Script for create & drop database
on 1/26/2010 | Views : 2888 | Status :
| Replies : 1
Write New Post
Un Answered Posts
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.....
Reply with Attachment
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:
There is something called SMO which lets you access the technology behind the Generate Scripts window. I think this would be your best bet:
, if this helps please
Mark As Answer
Login to post response
How to find the file path which was uploaded using AngularJS
Telerik Report ,Web form,Vb.net
How to created this type file in runtime.
How to Implemented for this Concept in C#
How to Design for this
How to Table Design for this Situation
How to Bind Menus in asp.menu control
How to increase heigh and width by 1 melemeter rdlc to bussiness card