Sponsored White Papers, Webcasts, and Downloads
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 >>