472,353 Members | 1,378 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,353 software developers and data experts.

Triggers


I'm just starting to use triggers in my databases and find the support
in Enterpise Manager lacking.

Using Enterprise Manager and Query Analyzer you can maintain the
triggers, but it's cumbersome.

Are there better tools for creating and managing triggers?

Mark Flippin

Jul 20 '05 #1
4 2350
Mark Flippin (me******@comcast.net) writes:
I'm just starting to use triggers in my databases and find the support
in Enterpise Manager lacking.

Using Enterprise Manager and Query Analyzer you can maintain the
triggers, but it's cumbersome.

Are there better tools for creating and managing triggers?


You don't specify what is cumbersome, but I can't see that trigger should
be any more cumbersome to use than stored procedure. That's true, that
maintaining anything from Enterprise Manager is cumbersome, and I usually
recommend people to stay awau from it...

In our shop we use a third-party text editor for all our SQL editing. This
editor, Textpad, has no special SQL capabilities, but is just a good editor.
As a devloper I load the SQL file through a command-line utility that
I fire off from within Textpad.

All our files are under source control. If we have a table widgets, the
definition for that table is in widgets.tbl. Indexes are in widgets.ix,
foreign keys are in widgets.fkey and triggers in widgets.tri. Normally
we have one object per file, with the name macthing the object, but
triggers are an exception. All triggers for one table is one file.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2
Hi

To add to Erlands comments you can script triggers to a window in the object
browser in QA, therefore there you can stay away from EM!!

John

"Mark Flippin" <me******@comcast.net> wrote in message
news:m9********************************@4ax.com...

I'm just starting to use triggers in my databases and find the support
in Enterpise Manager lacking.

Using Enterprise Manager and Query Analyzer you can maintain the
triggers, but it's cumbersome.

Are there better tools for creating and managing triggers?

Mark Flippin

Jul 20 '05 #3

Sorry,

By cumbersome, I meant finding the triggers and reviewing them. In EM,
there's too many steps, and you really can't get a feel for the
triggers for each table. The interface just doesn't flow.

I didn't realize that the triggers would show up in the QA object
browser. Thanks John.

This is more of what I was looking for, a quick graphical
representation of the triggers for a table, with the ability to
maintain them

The plus (to me anyways) is that the object browser provides that same
type of support for indices, constraints, and dependencies; items
that I've never really enjoyed maintaining with EM.

I've always used QA to develop and test my queries, procedures, udf's,
etc., but I've never really used the object browser. Ooops

I believe my use of EM is going to be significantly reduced.

Mark Flippin

Jul 20 '05 #4
Hi

Don't forget Erlands recommendation for using source code control. Using VC
and breaking down your objects into autonomous scripts, takes you away from
the need for using EM or even QA to find them. You gain auditability, the
ease of rolling back changes, ability to build any version of your database,
and reduced debugging time (especially in the scenarios where it had
previously seemed to work!). It's a very easy step to move to automated
builds at whatever frequency you require (and so catch problems earlier,
reduce your release process time and improved robustness and confidence).

John

"Mark Flippin" <me******@comcast.net> wrote in message
news:59********************************@4ax.com...

Sorry,

By cumbersome, I meant finding the triggers and reviewing them. In EM,
there's too many steps, and you really can't get a feel for the
triggers for each table. The interface just doesn't flow.

I didn't realize that the triggers would show up in the QA object
browser. Thanks John.

This is more of what I was looking for, a quick graphical
representation of the triggers for a table, with the ability to
maintain them

The plus (to me anyways) is that the object browser provides that same
type of support for indices, constraints, and dependencies; items
that I've never really enjoyed maintaining with EM.

I've always used QA to develop and test my queries, procedures, udf's,
etc., but I've never really used the object browser. Ooops

I believe my use of EM is going to be significantly reduced.

Mark Flippin

Jul 20 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: raulgz | last post by:
I need audit triggers that change columns value in the same record that fire trigger. I need how to do.. Thanks..
1
by: jason_s_ford | last post by:
I have several sql server databases that were recently moved to a new server. In the process of migrating the databases, any triggers and...
1
by: tim.pascoe | last post by:
I'm trying to generate scrips for a database, and everything so far has worked fine, except for the triggers. When I try and script existing...
4
by: stacdab | last post by:
We have a partitioned view with 4 underlying tables. The view and each of the underlying tables are in seperate databases on the same server....
5
by: Bruce | last post by:
I have several user defined functions which are referenced in triggers and views. For software upgrades, I need to be able to drop the triggers...
0
by: Bruno Lavoie | last post by:
Hello, i'm etablishing a naming convention for a new project under postgresql. For tables, sequences, views, that's ok! I used good naming...
0
debasisdas
by: debasisdas | last post by:
trigger sample code Ex#10 ======================= INSTEAD OF TRIGGER ---------------------------------------- create or replace trigger mytrig...
0
debasisdas
by: debasisdas | last post by:
This thread contains some useful tips/sample codes regarding TRIGGERS in oracle, that the forum members may find useful. TRIGGERS:...
4
by: --CELKO-- | last post by:
I need to convert a bunch of DB2 triggers to Oracle. Is there any kind of tools for this?
1
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...
0
by: Arjunsri | last post by:
I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and...
0
hi
by: WisdomUfot | last post by:
It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific...
0
by: Carina712 | last post by:
Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand....
0
BLUEPANDA
by: BLUEPANDA | last post by:
At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS...
0
by: Rahul1995seven | last post by:
Introduction: In the realm of programming languages, Python has emerged as a powerhouse. With its simplicity, versatility, and robustness, Python...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.