APS

Technical Article

RE: SQL SERVER 2000 trigger for Audit trail

  • Reply

Something like this should get you most of the way: create TRIGGER [name] ON FOR INSERT AS update set created_by = SUSER_SNAME(), last_modified_by = SUSER_SNAME(), date_created = GETDATE(), date_last_modified = GETDATE() from inserted where .Seqno = inserted.seqno; create TRIGGER [name] ON FOR UPDATE AS update set last_modified_by = SUSER_SNAME(), date_last_modified = GETDATE() from inserted where […]

2004-07-29

1 reads

Technical Article

RE: sql server 2000 trigger for checking duplicate email in a table

  • Reply

Hmmm - not quite sure what you're after. Do you have a 'person' table containing an e-mail field and want to maintain a separate table which contains just e-mail address (and, presumably, a foreign key back to the main 'person' table)? So do you therefore want to migrate your e-mail addresses away from your 'person' […]

2004-07-29

Blogs

New Pluralsight Course – Securing Azure Kubernetes Service (AKS) Clusters

By

My new course “Securing Azure Kubernetes Service (AKS) Clusters”, co-authored with my good friend...

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Read the latest Blogs

Forums

Case statement with time

By pedroccamara

Hello everyone I hope everyone's ok. I have this query and I'm trying to...

what are the best books to become a SQL developer?

By vpmaciel

what are the best books to become a SQL developer?

what are the best books to become a DBA SQL?

By vpmaciel

what are the best books to become a DBA SQL?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers