Trigger the best practice ?¿ - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Trigger the best practice ?¿

Author

Topic

Mjolnir
Starting Member

12 Posts

Posted - 2010-06-11 : 09:47:09

Hi,

I want to use a trigger to do the following:

The all complete registers are copied to other database with name DB_AUDITS is a real copy from DB_NORMAL.

the triggers is:


CREATE TRIGGER TD_ARCHIVOS ON dbo.ARCHIVOS
FOR INSERT, DELETE, UPDATE
AS
	Insert Into ARCHIVOS
		([ACID]
		Select 
		[ACID]
	From DELETED

	Insert Into ARCHIVOS
		([ACID]
		Select 
		[ACID]
	From INSERTED



End

GO