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 : 2868 | 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
ChEaP K-i-T-c-H-e-N-s FoR SaLe Trafford
select checkbox in datalist with out select link
what scenario using code first or entity framework
How to Fix this Issue Permanently in Sql Server
How to Restrict following Records in sql server
What is The Use of Method Hiding In C# although we having method overriding ?
Count the hit of website
how to compile two objects having same class in c# ?