Saving all triggers to a script

Hi,
Is there a simple way to save all triggers/ and or SP's to a Create script
in the same whay that you can save an individual trig/SP by right clicking it?
Thanks for any ideas on this is advance
Cheers
AntAnt
When you click on Generate Scripts menu , you have Options tab up to the
window. Click on it and check Script Triggers option
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:E0983BC0-796A-4801-9CE4-014AFED0A715@.microsoft.com...
> Hi,
> Is there a simple way to save all triggers/ and or SP's to a Create script
> in the same whay that you can save an individual trig/SP by right clicking
> it?
> Thanks for any ideas on this is advance
> Cheers
> Ant|||Hi Uri,
Thanks for your help though when I tried it, it simply created a script full
of exec dbOptions. Is this what I should be expecting?
I was hoping for a sql file filled with create trigger statements.
In Enterprise Manager, I went to Tools> Generate Scripts>
Checked thew Generate Create for each objecte & unchecked the Drop;
Security Scripting Options = Script Database (Had to check this/ didn't want
to)
Table Scripting Options = Script Triggers
But it didn't seem to work
Any ideas on this?
Cheers
Ant
"Uri Dimant" wrote:
> Ant
> When you click on Generate Scripts menu , you have Options tab up to the
> window. Click on it and check Script Triggers option
>
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:E0983BC0-796A-4801-9CE4-014AFED0A715@.microsoft.com...
> > Hi,
> >
> > Is there a simple way to save all triggers/ and or SP's to a Create script
> > in the same whay that you can save an individual trig/SP by right clicking
> > it?
> >
> > Thanks for any ideas on this is advance
> >
> > Cheers
> > Ant
>
>|||Ant
What version are you using? In SQL Server 2005 (with SP2 I think) you are be
able to script the objects per file
SQL Server 2000 , you can use SQL DMO object library
Sub ScriptDB(strLogin As String, strPwd As String, _
strDataBase As String, StrFilePath As String)
Dim sql As Object
Dim db As Object
Dim objTrigger As Object
Dim intOptions As Long
Dim genObj
Set sql = CreateObject("SQLDMO.SQLServer")
Set db = CreateObject("SQLDMO.Database")
Set objTrigger = CreateObject("SQLDMO.Trigger")
Const sDrops As Integer = 1
Const sIncludeHeaders As Long = 131072
Const sDefault As Integer = 4
Const sAppendToFile As Integer = 256
Const sBindings As Integer = 128
Const SQLDMOScript2_NoCollation As Long = 8388608
' Set scripting options. Because you need to specify multiple behaviors
' for the ScriptType argument, you use "Or" to combine these.
intOptions = sDrops Or sIncludeHeaders Or _
sDefault Or sAppendToFile Or sBindings Or SQLDMOScript2_NoCollation
' Connect to local server
sql.Connect "(local)", strLogin, strPwd
Set db = sql.Databases(strDataBase, "dbo")
' Script Tables and Triggers, ignoring system
' tables and system generated triggers
For Each genObj In db.Tables
If genObj.SystemObject = False Then
genObj.Script intOptions, StrFilePath,,SQLDMOScript2_NoCollation
For Each objTrigger In genObj.Triggers
If objTrigger.SystemObject = False Then
objTrigger.Script intOptions, StrFilePath
End If
Next
End If
Next
MsgBox "Finished generating SQL scripts."
End Sub
"Ant" <Ant@.discussions.microsoft.com> wrote in message
news:32A3B041-7CC3-44F9-803E-AB805E8356BC@.microsoft.com...
> Hi Uri,
> Thanks for your help though when I tried it, it simply created a script
> full
> of exec dbOptions. Is this what I should be expecting?
> I was hoping for a sql file filled with create trigger statements.
>
> In Enterprise Manager, I went to Tools> Generate Scripts>
> Checked thew Generate Create for each objecte & unchecked the Drop;
>
> Security Scripting Options = Script Database (Had to check this/ didn't
> want
> to)
> Table Scripting Options = Script Triggers
>
> But it didn't seem to work
> Any ideas on this?
> Cheers
> Ant
> "Uri Dimant" wrote:
>> Ant
>> When you click on Generate Scripts menu , you have Options tab up to the
>> window. Click on it and check Script Triggers option
>>
>>
>> "Ant" <Ant@.discussions.microsoft.com> wrote in message
>> news:E0983BC0-796A-4801-9CE4-014AFED0A715@.microsoft.com...
>> > Hi,
>> >
>> > Is there a simple way to save all triggers/ and or SP's to a Create
>> > script
>> > in the same whay that you can save an individual trig/SP by right
>> > clicking
>> > it?
>> >
>> > Thanks for any ideas on this is advance
>> >
>> > Cheers
>> > Ant
>>|||HI Uri,
Thank you, this will be applied to SQL2000 so it looks like the DMO object
library is the go.
Thanks very much for your help on this. Much appreciated
Ant
"Uri Dimant" wrote:
> Ant
> What version are you using? In SQL Server 2005 (with SP2 I think) you are be
> able to script the objects per file
>
> SQL Server 2000 , you can use SQL DMO object library
> Sub ScriptDB(strLogin As String, strPwd As String, _
> strDataBase As String, StrFilePath As String)
>
> Dim sql As Object
> Dim db As Object
> Dim objTrigger As Object
> Dim intOptions As Long
> Dim genObj
> Set sql = CreateObject("SQLDMO.SQLServer")
> Set db = CreateObject("SQLDMO.Database")
> Set objTrigger = CreateObject("SQLDMO.Trigger")
> Const sDrops As Integer = 1
> Const sIncludeHeaders As Long = 131072
> Const sDefault As Integer = 4
> Const sAppendToFile As Integer = 256
> Const sBindings As Integer = 128
> Const SQLDMOScript2_NoCollation As Long = 8388608
> ' Set scripting options. Because you need to specify multiple behaviors
> ' for the ScriptType argument, you use "Or" to combine these.
> intOptions = sDrops Or sIncludeHeaders Or _
> sDefault Or sAppendToFile Or sBindings Or SQLDMOScript2_NoCollation
> ' Connect to local server
> sql.Connect "(local)", strLogin, strPwd
> Set db = sql.Databases(strDataBase, "dbo")
>
> ' Script Tables and Triggers, ignoring system
> ' tables and system generated triggers
> For Each genObj In db.Tables
> If genObj.SystemObject = False Then
> genObj.Script intOptions, StrFilePath,,SQLDMOScript2_NoCollation
> For Each objTrigger In genObj.Triggers
> If objTrigger.SystemObject = False Then
> objTrigger.Script intOptions, StrFilePath
> End If
> Next
> End If
> Next
>
> MsgBox "Finished generating SQL scripts."
> End Sub
>
> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> news:32A3B041-7CC3-44F9-803E-AB805E8356BC@.microsoft.com...
> > Hi Uri,
> >
> > Thanks for your help though when I tried it, it simply created a script
> > full
> > of exec dbOptions. Is this what I should be expecting?
> >
> > I was hoping for a sql file filled with create trigger statements.
> >
> >
> > In Enterprise Manager, I went to Tools> Generate Scripts>
> > Checked thew Generate Create for each objecte & unchecked the Drop;
> >
> >
> > Security Scripting Options = Script Database (Had to check this/ didn't
> > want
> > to)
> > Table Scripting Options = Script Triggers
> >
> >
> > But it didn't seem to work
> >
> > Any ideas on this?
> >
> > Cheers
> >
> > Ant
> >
> > "Uri Dimant" wrote:
> >
> >> Ant
> >> When you click on Generate Scripts menu , you have Options tab up to the
> >> window. Click on it and check Script Triggers option
> >>
> >>
> >>
> >>
> >> "Ant" <Ant@.discussions.microsoft.com> wrote in message
> >> news:E0983BC0-796A-4801-9CE4-014AFED0A715@.microsoft.com...
> >> > Hi,
> >> >
> >> > Is there a simple way to save all triggers/ and or SP's to a Create
> >> > script
> >> > in the same whay that you can save an individual trig/SP by right
> >> > clicking
> >> > it?
> >> >
> >> > Thanks for any ideas on this is advance
> >> >
> >> > Cheers
> >> > Ant
> >>
> >>
> >>
>
>|||Another option is SMO. I would stay away from DMO as it's deprecated.
Here's a console app that uses SMO that will do this for you:
http://www.codeplex.com/scriptdb
On Sep 3, 1:54 am, Ant <A...@.discussions.microsoft.com> wrote:
> HI Uri,
> Thank you, this will be applied to SQL2000 so it looks like the DMO object
> library is the go.
> Thanks very much for your help on this. Much appreciated
> Ant
> "Uri Dimant" wrote:
> > Ant
> > What version are you using? InSQLServer 2005 (with SP2 I think) you are be
> > able toscriptthe objects per file
> >SQLServer 2000 , you can useSQLDMO object library
> > Sub ScriptDB(strLogin As String, strPwd As String, _
> > strDataBase As String, StrFilePath As String)
> > DimsqlAs Object
> > Dim db As Object
> > Dim objTrigger As Object
> > Dim intOptions As Long
> > Dim genObj
> > Setsql= CreateObject("SQLDMO.SQLServer")
> > Set db = CreateObject("SQLDMO.Database")
> > Set objTrigger = CreateObject("SQLDMO.Trigger")
> > Const sDrops As Integer = 1
> > Const sIncludeHeaders As Long = 131072
> > Const sDefault As Integer = 4
> > Const sAppendToFile As Integer = 256
> > Const sBindings As Integer = 128
> > Const SQLDMOScript2_NoCollation As Long = 8388608
> > ' Set scripting options. Because you need to specify multiple behaviors
> > ' for the ScriptType argument, you use "Or" to combine these.
> > intOptions = sDrops Or sIncludeHeaders Or _
> > sDefault Or sAppendToFile Or sBindings Or SQLDMOScript2_NoCollation
> > ' Connect to local server
> > sql.Connect "(local)", strLogin, strPwd
> > Set db =sql.Databases(strDataBase, "dbo")
> > 'ScriptTables and Triggers, ignoring system
> > ' tables and system generated triggers
> > For Each genObj In db.Tables
> > If genObj.SystemObject = False Then
> > genObj.ScriptintOptions, StrFilePath,,SQLDMOScript2_NoCollation
> > For Each objTrigger In genObj.Triggers
> > If objTrigger.SystemObject = False Then
> > objTrigger.ScriptintOptions, StrFilePath
> > End If
> > Next
> > End If
> > Next
> > MsgBox "Finished generatingSQLscripts."
> > End Sub
> > "Ant" <A...@.discussions.microsoft.com> wrote in message
> >news:32A3B041-7CC3-44F9-803E-AB805E8356BC@.microsoft.com...
> > > Hi Uri,
> > > Thanks for your help though when I tried it, it simply created ascript
> > > full
> > > of exec dbOptions. Is this what I should be expecting?
> > > I was hoping for asqlfile filled with create trigger statements.
> > > In Enterprise Manager, I went to Tools>GenerateScripts>
> > > Checked thewGenerateCreate for each objecte & unchecked the Drop;
> > > Security Scripting Options =ScriptDatabase (Had to check this/ didn't
> > > want
> > > to)
> > > Table Scripting Options =ScriptTriggers
> > > But it didn't seem to work
> > > Any ideas on this?
> > > Cheers
> > > Ant
> > > "Uri Dimant" wrote:
> > >> Ant
> > >> When you click onGenerateScripts menu , you have Options tab up to the
> > >> window. Click on it and checkScriptTriggers option
> > >> "Ant" <A...@.discussions.microsoft.com> wrote in message
> > >>news:E0983BC0-796A-4801-9CE4-014AFED0A715@.microsoft.com...
> > >> > Hi,
> > >> > Is there a simple way to save all triggers/ and or SP's to a Create
> > >> >script
> > >> > in the same whay that you can save an individual trig/SP by right
> > >> > clicking
> > >> > it?
> > >> > Thanks for any ideas on this is advance
> > >> > Cheers
> > >> > Ant|||Its SQL Server 2000 you cannot use SMO
"Jesse" <google@.jessehersch.fastmail.fm> wrote in message
news:1188941936.583258.128870@.57g2000hsv.googlegroups.com...
> Another option is SMO. I would stay away from DMO as it's deprecated.
> Here's a console app that uses SMO that will do this for you:
> http://www.codeplex.com/scriptdb
> On Sep 3, 1:54 am, Ant <A...@.discussions.microsoft.com> wrote:
>> HI Uri,
>> Thank you, this will be applied to SQL2000 so it looks like the DMO
>> object
>> library is the go.
>> Thanks very much for your help on this. Much appreciated
>> Ant
>> "Uri Dimant" wrote:
>> > Ant
>> > What version are you using? InSQLServer 2005 (with SP2 I think) you are
>> > be
>> > able toscriptthe objects per file
>> >SQLServer 2000 , you can useSQLDMO object library
>> > Sub ScriptDB(strLogin As String, strPwd As String, _
>> > strDataBase As String, StrFilePath As String)
>> > DimsqlAs Object
>> > Dim db As Object
>> > Dim objTrigger As Object
>> > Dim intOptions As Long
>> > Dim genObj
>> > Setsql= CreateObject("SQLDMO.SQLServer")
>> > Set db = CreateObject("SQLDMO.Database")
>> > Set objTrigger = CreateObject("SQLDMO.Trigger")
>> > Const sDrops As Integer = 1
>> > Const sIncludeHeaders As Long = 131072
>> > Const sDefault As Integer = 4
>> > Const sAppendToFile As Integer = 256
>> > Const sBindings As Integer = 128
>> > Const SQLDMOScript2_NoCollation As Long = 8388608
>> > ' Set scripting options. Because you need to specify multiple
>> > behaviors
>> > ' for the ScriptType argument, you use "Or" to combine these.
>> > intOptions = sDrops Or sIncludeHeaders Or _
>> > sDefault Or sAppendToFile Or sBindings Or SQLDMOScript2_NoCollation
>> > ' Connect to local server
>> > sql.Connect "(local)", strLogin, strPwd
>> > Set db =sql.Databases(strDataBase, "dbo")
>> > 'ScriptTables and Triggers, ignoring system
>> > ' tables and system generated triggers
>> > For Each genObj In db.Tables
>> > If genObj.SystemObject = False Then
>> > genObj.ScriptintOptions,
>> > StrFilePath,,SQLDMOScript2_NoCollation
>> > For Each objTrigger In genObj.Triggers
>> > If objTrigger.SystemObject = False Then
>> > objTrigger.ScriptintOptions, StrFilePath
>> > End If
>> > Next
>> > End If
>> > Next
>> > MsgBox "Finished generatingSQLscripts."
>> > End Sub
>> > "Ant" <A...@.discussions.microsoft.com> wrote in message
>> >news:32A3B041-7CC3-44F9-803E-AB805E8356BC@.microsoft.com...
>> > > Hi Uri,
>> > > Thanks for your help though when I tried it, it simply created
>> > > ascript
>> > > full
>> > > of exec dbOptions. Is this what I should be expecting?
>> > > I was hoping for asqlfile filled with create trigger statements.
>> > > In Enterprise Manager, I went to Tools>GenerateScripts>
>> > > Checked thewGenerateCreate for each objecte & unchecked the Drop;
>> > > Security Scripting Options =ScriptDatabase (Had to check this/ didn't
>> > > want
>> > > to)
>> > > Table Scripting Options =ScriptTriggers
>> > > But it didn't seem to work
>> > > Any ideas on this?
>> > > Cheers
>> > > Ant
>> > > "Uri Dimant" wrote:
>> > >> Ant
>> > >> When you click onGenerateScripts menu , you have Options tab up to
>> > >> the
>> > >> window. Click on it and checkScriptTriggers option
>> > >> "Ant" <A...@.discussions.microsoft.com> wrote in message
>> > >>news:E0983BC0-796A-4801-9CE4-014AFED0A715@.microsoft.com...
>> > >> > Hi,
>> > >> > Is there a simple way to save all triggers/ and or SP's to a
>> > >> > Create
>> > >> >script
>> > >> > in the same whay that you can save an individual trig/SP by right
>> > >> > clicking
>> > >> > it?
>> > >> > Thanks for any ideas on this is advance
>> > >> > Cheers
>> > >> > Ant
>|||Here, in this KB, Microsoft says SMO is compatible with 7.0, 2000 and 2005
Quote:
Because SMO is compatible with SQL Server version 7.0, SQL Server 2000, and
SQL Server 2005, you can also use SMO for configuration of SQL Server 2000.
Source: http://support.microsoft.com/default.aspx/kb/306397
--
Ekrem Önsoy
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eRLP9n57HHA.396@.TK2MSFTNGP06.phx.gbl...
> Its SQL Server 2000 you cannot use SMO
> "Jesse" <google@.jessehersch.fastmail.fm> wrote in message
> news:1188941936.583258.128870@.57g2000hsv.googlegroups.com...
>> Another option is SMO. I would stay away from DMO as it's deprecated.
>> Here's a console app that uses SMO that will do this for you:
>> http://www.codeplex.com/scriptdb
>> On Sep 3, 1:54 am, Ant <A...@.discussions.microsoft.com> wrote:
>> HI Uri,
>> Thank you, this will be applied to SQL2000 so it looks like the DMO
>> object
>> library is the go.
>> Thanks very much for your help on this. Much appreciated
>> Ant
>> "Uri Dimant" wrote:
>> > Ant
>> > What version are you using? InSQLServer 2005 (with SP2 I think) you
>> > are be
>> > able toscriptthe objects per file
>> >SQLServer 2000 , you can useSQLDMO object library
>> > Sub ScriptDB(strLogin As String, strPwd As String, _
>> > strDataBase As String, StrFilePath As String)
>> > DimsqlAs Object
>> > Dim db As Object
>> > Dim objTrigger As Object
>> > Dim intOptions As Long
>> > Dim genObj
>> > Setsql= CreateObject("SQLDMO.SQLServer")
>> > Set db = CreateObject("SQLDMO.Database")
>> > Set objTrigger = CreateObject("SQLDMO.Trigger")
>> > Const sDrops As Integer = 1
>> > Const sIncludeHeaders As Long = 131072
>> > Const sDefault As Integer = 4
>> > Const sAppendToFile As Integer = 256
>> > Const sBindings As Integer = 128
>> > Const SQLDMOScript2_NoCollation As Long = 8388608
>> > ' Set scripting options. Because you need to specify multiple
>> > behaviors
>> > ' for the ScriptType argument, you use "Or" to combine these.
>> > intOptions = sDrops Or sIncludeHeaders Or _
>> > sDefault Or sAppendToFile Or sBindings Or SQLDMOScript2_NoCollation
>> > ' Connect to local server
>> > sql.Connect "(local)", strLogin, strPwd
>> > Set db =sql.Databases(strDataBase, "dbo")
>> > 'ScriptTables and Triggers, ignoring system
>> > ' tables and system generated triggers
>> > For Each genObj In db.Tables
>> > If genObj.SystemObject = False Then
>> > genObj.ScriptintOptions,
>> > StrFilePath,,SQLDMOScript2_NoCollation
>> > For Each objTrigger In genObj.Triggers
>> > If objTrigger.SystemObject = False Then
>> > objTrigger.ScriptintOptions, StrFilePath
>> > End If
>> > Next
>> > End If
>> > Next
>> > MsgBox "Finished generatingSQLscripts."
>> > End Sub
>> > "Ant" <A...@.discussions.microsoft.com> wrote in message
>> >news:32A3B041-7CC3-44F9-803E-AB805E8356BC@.microsoft.com...
>> > > Hi Uri,
>> > > Thanks for your help though when I tried it, it simply created
>> > > ascript
>> > > full
>> > > of exec dbOptions. Is this what I should be expecting?
>> > > I was hoping for asqlfile filled with create trigger statements.
>> > > In Enterprise Manager, I went to Tools>GenerateScripts>
>> > > Checked thewGenerateCreate for each objecte & unchecked the Drop;
>> > > Security Scripting Options =ScriptDatabase (Had to check this/
>> > > didn't
>> > > want
>> > > to)
>> > > Table Scripting Options =ScriptTriggers
>> > > But it didn't seem to work
>> > > Any ideas on this?
>> > > Cheers
>> > > Ant
>> > > "Uri Dimant" wrote:
>> > >> Ant
>> > >> When you click onGenerateScripts menu , you have Options tab up to
>> > >> the
>> > >> window. Click on it and checkScriptTriggers option
>> > >> "Ant" <A...@.discussions.microsoft.com> wrote in message
>> > >>news:E0983BC0-796A-4801-9CE4-014AFED0A715@.microsoft.com...
>> > >> > Hi,
>> > >> > Is there a simple way to save all triggers/ and or SP's to a
>> > >> > Create
>> > >> >script
>> > >> > in the same whay that you can save an individual trig/SP by right
>> > >> > clicking
>> > >> > it?
>> > >> > Thanks for any ideas on this is advance
>> > >> > Cheers
>> > >> > Ant
>>
>|||Hi
I meant you can use SMO only in .NET technologies. Sorry , my mistake
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:5A8AEF56-3DFA-4D2B-BB71-97EB9C4D288B@.microsoft.com...
> Here, in this KB, Microsoft says SMO is compatible with 7.0, 2000 and 2005
> Quote:
> Because SMO is compatible with SQL Server version 7.0, SQL Server 2000,
> and SQL Server 2005, you can also use SMO for configuration of SQL Server
> 2000.
> Source: http://support.microsoft.com/default.aspx/kb/306397
> --
> Ekrem Önsoy
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eRLP9n57HHA.396@.TK2MSFTNGP06.phx.gbl...
>> Its SQL Server 2000 you cannot use SMO
>> "Jesse" <google@.jessehersch.fastmail.fm> wrote in message
>> news:1188941936.583258.128870@.57g2000hsv.googlegroups.com...
>> Another option is SMO. I would stay away from DMO as it's deprecated.
>> Here's a console app that uses SMO that will do this for you:
>> http://www.codeplex.com/scriptdb
>> On Sep 3, 1:54 am, Ant <A...@.discussions.microsoft.com> wrote:
>> HI Uri,
>> Thank you, this will be applied to SQL2000 so it looks like the DMO
>> object
>> library is the go.
>> Thanks very much for your help on this. Much appreciated
>> Ant
>> "Uri Dimant" wrote:
>> > Ant
>> > What version are you using? InSQLServer 2005 (with SP2 I think) you
>> > are be
>> > able toscriptthe objects per file
>> >SQLServer 2000 , you can useSQLDMO object library
>> > Sub ScriptDB(strLogin As String, strPwd As String, _
>> > strDataBase As String, StrFilePath As String)
>> > DimsqlAs Object
>> > Dim db As Object
>> > Dim objTrigger As Object
>> > Dim intOptions As Long
>> > Dim genObj
>> > Setsql= CreateObject("SQLDMO.SQLServer")
>> > Set db = CreateObject("SQLDMO.Database")
>> > Set objTrigger = CreateObject("SQLDMO.Trigger")
>> > Const sDrops As Integer = 1
>> > Const sIncludeHeaders As Long = 131072
>> > Const sDefault As Integer = 4
>> > Const sAppendToFile As Integer = 256
>> > Const sBindings As Integer = 128
>> > Const SQLDMOScript2_NoCollation As Long = 8388608
>> > ' Set scripting options. Because you need to specify multiple
>> > behaviors
>> > ' for the ScriptType argument, you use "Or" to combine these.
>> > intOptions = sDrops Or sIncludeHeaders Or _
>> > sDefault Or sAppendToFile Or sBindings Or
>> > SQLDMOScript2_NoCollation
>> > ' Connect to local server
>> > sql.Connect "(local)", strLogin, strPwd
>> > Set db =sql.Databases(strDataBase, "dbo")
>> > 'ScriptTables and Triggers, ignoring system
>> > ' tables and system generated triggers
>> > For Each genObj In db.Tables
>> > If genObj.SystemObject = False Then
>> > genObj.ScriptintOptions,
>> > StrFilePath,,SQLDMOScript2_NoCollation
>> > For Each objTrigger In genObj.Triggers
>> > If objTrigger.SystemObject = False Then
>> > objTrigger.ScriptintOptions, StrFilePath
>> > End If
>> > Next
>> > End If
>> > Next
>> > MsgBox "Finished generatingSQLscripts."
>> > End Sub
>> > "Ant" <A...@.discussions.microsoft.com> wrote in message
>> >news:32A3B041-7CC3-44F9-803E-AB805E8356BC@.microsoft.com...
>> > > Hi Uri,
>> > > Thanks for your help though when I tried it, it simply created
>> > > ascript
>> > > full
>> > > of exec dbOptions. Is this what I should be expecting?
>> > > I was hoping for asqlfile filled with create trigger statements.
>> > > In Enterprise Manager, I went to Tools>GenerateScripts>
>> > > Checked thewGenerateCreate for each objecte & unchecked the Drop;
>> > > Security Scripting Options =ScriptDatabase (Had to check this/
>> > > didn't
>> > > want
>> > > to)
>> > > Table Scripting Options =ScriptTriggers
>> > > But it didn't seem to work
>> > > Any ideas on this?
>> > > Cheers
>> > > Ant
>> > > "Uri Dimant" wrote:
>> > >> Ant
>> > >> When you click onGenerateScripts menu , you have Options tab up to
>> > >> the
>> > >> window. Click on it and checkScriptTriggers option
>> > >> "Ant" <A...@.discussions.microsoft.com> wrote in message
>> > >>news:E0983BC0-796A-4801-9CE4-014AFED0A715@.microsoft.com...
>> > >> > Hi,
>> > >> > Is there a simple way to save all triggers/ and or SP's to a
>> > >> > Create
>> > >> >script
>> > >> > in the same whay that you can save an individual trig/SP by
>> > >> > right
>> > >> > clicking
>> > >> > it?
>> > >> > Thanks for any ideas on this is advance
>> > >> > Cheers
>> > >> > Ant
>>
>>
>