Home > Archive > microsoft.public.sqlserver.server > June 2002 > triggers





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author triggers
Tanya

2002-06-25, 4:25 am

I want to create or amend triggers using enterprise
manager in sql 2000 as I did in sql 7.
When you do [all tasks], '[manage triggers], you can type
in the trigger but there is no button for [create
trigger], none for [delete trigger], and none to even the
close the window, and no x in the top right to close the
window.
How do I get out of this without having to close the
application using task manager?
Andrew J. Kelly

2002-06-25, 7:25 am

I don't know what you doing differently but when I select "Manage Triggers"
it comes up with a sample "CREATE TRIGGER" script and the bottom of the
dialog has OK and CLOSE buttons.

--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.



"Tanya" <t.isdale@mmu.ac.uk> wrote in message
news:103bc01c21c2d$bf51a460$2a
e2c90a@hosting.microsoft.com...
> I want to create or amend triggers using enterprise
> manager in sql 2000 as I did in sql 7.
> When you do [all tasks], '[manage triggers], you can type
> in the trigger but there is no button for [create
> trigger], none for [delete trigger], and none to even the
> close the window, and no x in the top right to close the
> window.
> How do I get out of this without having to close the
> application using task manager?



Sadiq

2002-06-25, 10:25 am


When i do this i get OK, CLOSE buttons at the bottom.

I guess, you have to hide the task bar in order to see
these buttons which are at the bottom.

Sadiq


>-----Original Message-----
>I don't know what you doing differently but when I

select "Manage Triggers"
>it comes up with a sample "CREATE TRIGGER" script and the

bottom of the
>dialog has OK and CLOSE buttons.
>
>--
>Andrew J. Kelly SQL MVP
>Targitinteractive, Inc.
>
>
>
>"Tanya" <t.isdale@mmu.ac.uk> wrote in message
>news:103bc01c21c2d$bf51a460

$2ae2c90a@hosting.microsoft.com...
>> I want to create or amend triggers using enterprise
>> manager in sql 2000 as I did in sql 7.
>> When you do [all tasks], '[manage triggers], you can

type
>> in the trigger but there is no button for [create
>> trigger], none for [delete trigger], and none to even

the
>> close the window, and no x in the top right to close the
>> window.
>> How do I get out of this without having to close the
>> application using task manager?

>
>
>.
>

Andrew J. Kelly

2002-06-25, 11:25 am

If the Task bar is blocking ht bottom of your dialog then yes you should
hide it or resize your dialog.

--
Andrew J. Kelly SQL MVP
Targitinteractive, Inc.



"Sadiq" <sadiql@hotmail.com> wrote in message
news:11f0e01c21c61$0ce8bd20$9a
e62ecf@tkmsftngxa02...
>
> When i do this i get OK, CLOSE buttons at the bottom.
>
> I guess, you have to hide the task bar in order to see
> these buttons which are at the bottom.
>
> Sadiq
>
>
> >-----Original Message-----
> >I don't know what you doing differently but when I

> select "Manage Triggers"
> >it comes up with a sample "CREATE TRIGGER" script and the

> bottom of the
> >dialog has OK and CLOSE buttons.
> >
> >--
> >Andrew J. Kelly SQL MVP
> >Targitinteractive, Inc.
> >
> >
> >
> >"Tanya" <t.isdale@mmu.ac.uk> wrote in message
> >news:103bc01c21c2d$bf51a460

> $2ae2c90a@hosting.microsoft.com...
> >> I want to create or amend triggers using enterprise
> >> manager in sql 2000 as I did in sql 7.
> >> When you do [all tasks], '[manage triggers], you can

> type
> >> in the trigger but there is no button for [create
> >> trigger], none for [delete trigger], and none to even

> the
> >> close the window, and no x in the top right to close the
> >> window.
> >> How do I get out of this without having to close the
> >> application using task manager?

> >
> >
> >.
> >



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net