On TV.com: ANGELINA JOLIE looks stunning as usual
2 Resources for

data definition language trigger

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Document Sarbanes-Oxley compliance with SQL Server 2005
As the DBA for revenue-generating applications, I am frequently invited by my CIO to meetings with Sarbanes-Oxley auditors to discuss the security and integrity of corporate data. In a nutshell, we're expected to answer any number of questions, via appropriate documentation, about who has access to our data, how access...
Tags: Sarbanes-Oxley Compliance, Audit, Event, Sarbanes-Oxley Act, DDL, Microsoft SQL Server, Trigger, Microsoft SQL Server 2005, Data Definition Language Trigger, Data Definition Language Event, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-04-07
Using SQL Server 2005 to document Sarbanes-Oxley compliance
By Tim ChapmanAs the DBA for revenue-generating applications, I amfrequently invited by my CIO to meetings with Sarbanes-Oxley auditors todiscuss the security and integrity of corporate data. In a nutshell, we'reexpected to answer any number of questions, via appropriate documentation,about who has access to our data, how access is granted,...
Tags: audit, audit trail, data definition language trigger, database, DDL, Microsoft SQL Server, Microsoft SQL Server 2005, Sarbanes-Oxley Act, Sarbanes-Oxley compliance, server, trail, trigger
Technical articles 2006-05-09

Additional Resources

MSDN Webcast: New T-SQL Programmability Features in SQL Server 2008 (Level 300)
This webcast on new T-SQL programmability features in Microsoft SQL Server 2008. It covers exciting new features such as new data types (i.e. date/time, filestream, HierarchyID, large UDT, sparse columns), dependency management for database objects, procedure programming (i.e. table value parameter), data warehousing enhancements (i.e. Merge data manipulation language DML...
Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Microsoft SQL Server 2008, Data Warehouse, Webcast, Microsoft SQL Server, Microsoft Corp., Databases, Business Intelligence, Storage, Enterprise Software, Software, Data Management, Hardware
Webcasts 2007-12-04
Trapping Updated Records
Can a SQL Trigger be created on a Table that will determine which record in that Table was actually updated?Sort ofWhen an Update trigger firesthe the changed records are in the deleted table and the new versions of them in the Inserted table.At this point you have access to the...
Tags: jwc1410@...
Discussion threads 2007-05-22
Making use of INSTEAD-OF triggers in SQL Server 2005
INSTEAD-OF triggers are powerful objects in SQL Server 2005. Tim Chapman explores some of the useful features of INSTEAD-OF triggers, and discusses how your organization can use them to its advantage. A trigger is a database object similar to a stored procedure that executes in response to certain...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Databases, Storage, INSTEAD-OF INSERT, trigger, INSTEAD-OF trigger, database, SQL Server Newsletter, View, Table, INSTEAD-OF, Enterprise Software, Software, Data Management, Hardware
Technical articles 2006-09-11
Using a Single Trigger for Insert and Update
I have been trying to handle Insert and Update using one trigger. Does anydody know how to detect that a row is being updated in SQL Server 2005? Thanks.William.A couple of ideasif you have common code to run for both transactions put it in a stored proc and the call...
Tags: wcovuaku@..., programming, trigger
Discussion threads 2007-02-22
Edit Trigger
In SQL 2000, how do you EDIT a Trigger?Creating one works fine but there doesn't seem to be a way to actually edit the code to update the Trigger.
Tags: Programming languages, jwc1410@...
Discussion threads 2007-05-23
DC Binding Recordset (exe)
Few Lines to add in your Form_Load event and you will get full control over your form and all included and all related events. You can: navigate first, previous, next, and last. Add new records, edit it, save it, or delete it. Retrieve related names to your fields code. Trigger...
Tags: Entry, Mice, Hardware, Peripherals
Software downloads 2006-05-12
XML Schema Registration and Validation
An XML schema defines the structure of an XML document by setting constraints on the data types of elements and attributes in the document. XML documents can be validated against the XML schema to ensure they conform to the constraints defined in the schema. There are several schema languages that...
Tags: XML Schema, XML, Software/Web Development, Web Development
White papers 2006-09-27
Webcam Zone Trigger (exe)
Zone Trigger is innovative, intelligent motion detection software that gives you full control over the area being monitored. Because of its user-friendly, object-oriented interface, Zone Trigger is very easy to use and allows you to do thing that motion detection software could not do before. Version 1.8 contains a new...
Tags: webcam, object-oriented, software
Software downloads 2006-10-25
Learn to avoid the mutating table problem in Oracle
triggertrigger
Tags: it management, Oracle Corp., sdkjf@..., trigger
Discussion threads 2005-07-05
Understanding INSTEAD OF Triggers in Microsoft SQL Server 2000
During this presentation, we will talk about one of the new features introduced in Microsoft SQL Server 2000, INSTEAD OF triggers. In SQL Server version 7.0 and earlier, triggers are implemented in a before fashion. In other words, any constraint checks are performed after the insert is attempted. The INSTEAD...
Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Trigger, Microsoft Corp., Databases, Enterprise Software, Software, Data Management
Webcasts
Oracle PL/SQL Developer's Workbook: Triggers
A trigger is a block of code (whether in PL/SQL, Java, or C) that fires, or executes, in response to a specific event. A trigger executes implicitly in response to an event, such as an update to a table. A procedure executes explicitly at the request of a user (or...
Tags: Developer, Procedure, Oracle Corp., Trigger, Programming Languages, C/C++, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
Book chapters 2000-05-01
An Overview of the M Language
The MIT Data Center is moving into a new stage of development and application of the M Language. This paper gives an overview of the M Language along with applications. Designed to enhance data interoperability, the M Language serves as a base for the intelligent information infrastructure of the future.
Tags: Massachusetts Institute Of Technology, MIT Data Center, Data Centers, Storage, Hardware, Data Management
White papers 2006-01-12
Control Risk by Controlling E-mail Content
One of the most effective ways for employers to reduce electronic risks is also one of the simplest. By requiring employees to use appropriate, businesslike language in e-mail and other electronic documents, employers can limit their liability risks and improve the overall effectiveness of the organization's e-communications. Language that is...
Tags: Language, E-mail, Online Communications
White papers
Call multiple trigger bodies with a single trigger
Or just use Oracle 8, 9 or 10This article shows how to jump through some hoops to get the effect of multiple triggers of the same type on a table. The restriction of just one trigger of each type was lifted in the Oracle database several versions ago, so...
Tags: Databases, trigger
Discussion threads 2005-08-25
Find Error Description (exe)
The ErrorShow program requires a message definition as input. The caller can ask the program to search the system's message table resources for the message definition. The program finds the message definition in a message table resource based on a message identifier and a language identifier. The program copies the...
Tags: Message, ErrorShow Program, Message Definition
Software downloads 2006-02-17
Definition Finder (exe)
Definition Finder allows you to search for any word on your screen by just pressing the Alt key and highlighting the word. The program doesn't go to any Web site to show you the definition, rather the definition if displayed instantly next to the highlighted word. You also have the...
Tags: Word, Definition, Definition Finder, Web Site Development, Construction, Web Technology, Channel Management, Internet, Marketing
Software downloads 2006-02-27
Know your DML: The new OUTPUT feature in SQL Server 2005
SQL TRIGGERhow can we create a trigger to insert a new record.
Tags: Databases, roopesh84@..., Microsoft SQL Server 2005, Microsoft SQL Server
Discussion threads 2007-10-08
SMS Messaging Server (exe)
SMS messaging framework for sending, receiving, and processing SMS and e-mail messages. Supports SMPP (SMS messaging through the Internet, using an SMPP provider), GSM modems (including WaveCom, MultiTech, and Siemens) and GSM07.05 or GSM07.07 compliant phones (including Nokia, Sony-Ericsson, Motorola, and Siemens). Trigger incoming messages and define custom actions by...
Tags: SMS, VBScript Scripting Language, ActiveXperts SMS Messaging Server, Text Messaging/SMS/MMS, Telephony, Cellular Phones, Consumer Electronics, Personal Technology, Online Communications, Networking
Software downloads 2005-07-13
  • << Previous
  • page 1 of 1
  • Next >>

Content Types

Blog posts (1 results)
Technical articles (1 results)


Disaster Recovery Plan Power Checklist
Development of a disaster recovery plan is a must. Although there may never come a time when the plan must be implemented, it is always best to prepar ...
Buy Now
Storage Security Policy
Safely retaining and securing data is an important aspect of an effective security strategy. Business demands, increased user requirements and even co ...
Buy Now