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 : 2841 | 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
Information on Dot net Platform
SSRS report through C#.
Build the application time get the below error
How to close the respective modal dialog when switch over to other modal dialog without overlapping
how to save and use variable in jquery
How to add Parameterized Image in RDLC report?
How to Solve this Hosting Issues.
How do i get payment status in redirect page using bitpay?