Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags SQL Server 7, Triggers Rss

   Items 1 to 14 of 14   
 

Using DDL Database Triggers

In this short demonstration, you'll learn how to use DDL database triggers to prevent changes to product and audit changes to comply with Sarbanes-Oxley and other change management requirements. Free registration required.   Read more...
By Brian Knight 2006/07/20 | Source: Other | Category: triggers
Rating:  Rate this |   Briefcase | 3,163 reads

Stored Procedure vs Triggers

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.   Read more...
By Gulappa Vijaya Kumar 2006/03/31 (first published: 2004/08/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 38,956 reads

Triggers in SQL Server 7.0 and 2000 - What's New

This is the second of a two part series on how triggers work in the two latest versions of MS SQL Server. The first part dealt with what is common between the two versions. This article will detail what's been added to SQL Server 2000.   Read more...
By Brian Kelley 2005/06/24 (first published: 2001/09/03) | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 72,577 reads

Triggers in SQL Server 7.0 and 2000 - The Common Ground

This is a two part series on how triggers work in the two latest versions of MS SQL Server. Because there are some pretty significant additions in trigger functionality from 7.0 to 2000, we'll first need to look at what the two versions have in common. The second part to this series will look at the differences between the two MS SQL Server versions.   Read more...
By Brian Kelley 2005/01/21 (first published: 2001/07/31) | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 110,488 reads

Stored Procedure vs Triggers

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.   Read more...
By Gulappa Vijaya Kumar 2006/03/31 (first published: 2004/08/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 38,956 reads

Worst Practice - Triggering External Events

Andy Warren started his worst practice series some time ago with the intention of looking at the worst things you can do. Given that we may not always be able to implement the best practices, at least we can try to avoid doing things harm the system or decrease performance. This article continues the series and looks at an item I see mentioned in our discussion forum quite often, triggering external events. From a trigger.   Read more...
By Steve Jones 2004/02/23 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 9,779 reads

Auditing Through Triggers

In this article by Robert Marda, he shows you how to setup a simple auditing system through triggers.   Read more...
By Robert Marda 2004/01/16 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 16,482 reads

Testing for an Updated Column in a Trigger

The columns_updated function gives you the ability to easily test to see if specific columns were modified with less code than you might otherwise need to use. In this article Andy Warren demonstrates how to create a trigger that uses this function and points out some reasons why you may NOT want to use it!   Read more...
By Andy Warren 2003/08/21 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 17,799 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,204 reads

Creating your own sp_MSforeach stored procedure

This article shows you one of the most time saving stored procedure built into SQL Server and then shows you how you can modify it to affect additional objects like triggers. For example, after this article and the code in the article, you'll be able to disable every trigger in your system in one line of code.   Read more...
By Brian Knight 2002/06/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 14,846 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 6,398 reads

Triggers in SQL Server 7.0 and 2000 - What's New

This is the second of a two part series on how triggers work in the two latest versions of MS SQL Server. The first part dealt with what is common between the two versions. This article will detail what's been added to SQL Server 2000.   Read more...
By Brian Kelley 2005/06/24 (first published: 2001/09/03) | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 72,577 reads

Triggers in SQL Server 7.0 and 2000 - The Common Ground

This is a two part series on how triggers work in the two latest versions of MS SQL Server. Because there are some pretty significant additions in trigger functionality from 7.0 to 2000, we'll first need to look at what the two versions have in common. The second part to this series will look at the differences between the two MS SQL Server versions.   Read more...
By Brian Kelley 2005/01/21 (first published: 2001/07/31) | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 110,488 reads

SQL Server 2000: .NET and the Death and Re-Birth o

In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.   Read more...
By Additional Articles 2001/07/27 | Source: Microsoft MSDN | Category: triggers
Rating:  Rate this |   Briefcase | 1,311 reads
   Items 1 to 14 of 14   
 
Tags
stored procedures (4)    
t-sql (4)    
administration (3)    
backup / restore (2)    
configuring (2)    
dts (2)    
indexing (2)    
installation (2)    
miscellaneous (2)    
performance tuning (2)    
security (2)    
user defined function (udf) (2)    
advanced querying (1)    
best and worst practices (1)    
distributed queries (1)    
english query (1)    
monitoring (1)    
openxml (1)    
replication (1)    
updategrams (1)    
worst practices (1)    
xml (1)    
xsl (1)