Restore Default Trigger Template

Hello,
I am locally running SS2K, but the database is sitting on a SS7 server. I
created a trigger and accidentally clicked the "Save As Template" button.
Is there any way to set the template back to the default?Did you overwrite one of your trigger templates? Which one? You may be able to get it from another machine that has the =client tools installed on your network. Perhaps you could find the =appropriate .tql file on the SQL Server CD.
-- Keith
"Steven K" <sckeels@.lucent.com> wrote in message =news:ucs4#yMbDHA.2668@.TK2MSFTNGP09.phx.gbl...
> Hello,
> > I am locally running SS2K, but the database is sitting on a SS7 =server. I
> created a trigger and accidentally clicked the "Save As Template" =button.
> Is there any way to set the template back to the default?
> >|||Thanks Keith, I overwrote the "new" template. I will get it from another
machine.
"Keith Kratochvil" <keith.kratochvil.back2u@.novusprintmedia.com> wrote in
message news:OUfh9pNbDHA.2588@.TK2MSFTNGP09.phx.gbl...
Did you overwrite one of your trigger templates?
Which one? You may be able to get it from another machine that has the
client tools installed on your network. Perhaps you could find the
appropriate .tql file on the SQL Server CD.
--
Keith
"Steven K" <sckeels@.lucent.com> wrote in message
news:ucs4#yMbDHA.2668@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I am locally running SS2K, but the database is sitting on a SS7 server. I
> created a trigger and accidentally clicked the "Save As Template" button.
> Is there any way to set the template back to the default?
>

restore backup

I have a copy of a database to install and work with locally (work from my
own pc at home instead of in the office). I have a copy of the bak file, how
can I install that on my SQL Server and use the database?
NuB,
Use either Enterprise Manager - Restore or the T-SQL RESTORE statement.
See:
'How to restore a backup from a backup device (Enterprise Manager)' in the
SQL Books Online
or
'RESTORE' in the SQL Books Online. (examples included)
HTH
Jerry
"NuB" <me@.me.com> wrote in message
news:eKQGG5L2FHA.2932@.TK2MSFTNGP10.phx.gbl...
>I have a copy of a database to install and work with locally (work from my
>own pc at home instead of in the office). I have a copy of the bak file,
>how can I install that on my SQL Server and use the database?
>
>

restore backup

I have a copy of a database to install and work with locally (work from my
own pc at home instead of in the office). I have a copy of the bak file, how
can I install that on my SQL Server and use the database?NuB,
Use either Enterprise Manager - Restore or the T-SQL RESTORE statement.
See:
'How to restore a backup from a backup device (Enterprise Manager)' in the
SQL Books Online
or
'RESTORE' in the SQL Books Online. (examples included)
HTH
Jerry
"NuB" <me@.me.com> wrote in message
news:eKQGG5L2FHA.2932@.TK2MSFTNGP10.phx.gbl...
>I have a copy of a database to install and work with locally (work from my
>own pc at home instead of in the office). I have a copy of the bak file,
>how can I install that on my SQL Server and use the database?
>
>

restore backup

I have a copy of a database to install and work with locally (work from my
own pc at home instead of in the office). I have a copy of the bak file, how
can I install that on my SQL Server and use the database?NuB,
Use either Enterprise Manager - Restore or the T-SQL RESTORE statement.
See:
'How to restore a backup from a backup device (Enterprise Manager)' in the
SQL Books Online
or
'RESTORE' in the SQL Books Online. (examples included)
HTH
Jerry
"NuB" <me@.me.com> wrote in message
news:eKQGG5L2FHA.2932@.TK2MSFTNGP10.phx.gbl...
>I have a copy of a database to install and work with locally (work from my
>own pc at home instead of in the office). I have a copy of the bak file,
>how can I install that on my SQL Server and use the database?
>
>