SQLDMO Script method

• sqld-_-ba

  SSCarpal Tunnel

  Points: 4365

  More actions

  April 3, 2008 at 8:19 am

  #188650

  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

• sqld-_-ba

  SSCarpal Tunnel

  Points: 4365

  More actions

  April 8, 2008 at 12:06 pm

  #799937

  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")