Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLDMO Script method Expand / Collapse
Author
Message
Posted Thursday, April 3, 2008 8:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 20, 2014 4:24 PM
Points: 65, Visits: 709
What option number to give to include db name in the script output

Ex: databases("pubs").storeprocedures("abcSP").script( ?? ,"c:\abc.sql")
'use pubs
go
create proc
...'

http://www.dbazine.com/sql/sql-articles/larsen4 - this is where i started

http://msdn2.microsoft.com/en-us/library/ms135191.aspx - this doesn't have option '256' (listed in above article)

then went here - http://doc.ddart.net/mssql/sql70/9_dmor81_2.htm
is this all list of options or there is more ?

i tried including all the numbers 1|2|4|32|34.. |131072
but it doesn't script 'use db' !

thanks
Post #479244
Posted Tuesday, April 8, 2008 12:06 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, February 20, 2014 4:24 PM
Points: 65, Visits: 709
Is there an option number to script triggers of a table, by specifying only the table name ?
|Option no.|
Ex: Databases("pubs").Tables("names").Script ( ?? ,"c:ames.sql")
should script TRG_names_del

instead of having to explicitly give:
Databases("pubs").Triggers("TRG_names_del").Script ( ?? , "c:ames.sql")
Post #481779
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse