473,721 Members | 2,411 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2538
Mark Flippin (me******@comca st.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****@sommarsk og.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******@comca st.net> wrote in message
news:m9******** *************** *********@4ax.c om...

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******@comca st.net> wrote in message
news:59******** *************** *********@4ax.c om...

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
6630
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
2094
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 constraints attached to tables were removed on accident. I need to add these objects back into the databases, however I'm worried that I will have problems with referential integrity since there is a chance someone may have deleted or updated a record that should have cascaded changes to other tables...
1
1829
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 triggers, all I get is a blank file - no SQL script. I tried single files for each object, all in one file, triggers only, the entire database. I can't figure it out, but I know the triggers are there. Any suggestions, or am I missing something undocumented in SQL-Server 2000?
4
2716
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. Inserts and deletes on the view work fine. We then add insert and delete triggers to each of the underlying tables. The triggers modify a different set of tables in the same database as the view (different than the underlying table). The problem is those triggers aren't fired when inserting or...
5
2445
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 and views which reference these user defined functions, then drop and recreate the user defined functions, then recreate all the views and triggers. I don't imiagine I'm the first person who needed to do this, and I don't have a lot of db2 experience, so I wanted to see if there is a common or...
0
4932
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 conventions for this in the past and i'll keep these rules for the new project. but, i plan to use a lot of triggers and functions in this project, but I'm confused! I know that triggers call already created functions. But for tracking i must be able to associate these 2 different object
0
8326
debasisdas
by: debasisdas | last post by:
trigger sample code Ex#10 ======================= INSTEAD OF TRIGGER ---------------------------------------- create or replace trigger mytrig instead of delete or insert or update on eview declare a number(2); begin
0
4492
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: =============== Database trigger is a PL/SQL block that is executed on an event in the database. The event is related to a particular data manipulation of a table such as inserting, deleting or updating a row of a table. Triggers may be used : 1.To implement complex business rule, which cannot be...
4
5744
by: --CELKO-- | last post by:
I need to convert a bunch of DB2 triggers to Oracle. Is there any kind of tools for this?
0
8851
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8736
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9373
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9227
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9138
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
6676
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5992
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4761
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3201
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

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.