Are you sure that you want an trigger and not a constraint?

-Dave


-----Original Message-----
From: Pillai Sreelatha
[mailto:mssqldba-ezmlmshield-x77229785.[Email address protected]
Sent: Tuesday, April 29, 2008 12:04 PM
To: LazyDBA Discussion
Subject: Trigger creation

I need to get a trigger on Table A for createddate column which cannot
be null or ' ' or 1/1/1900 when doing an insert/update. This should work
for multiple inserts/updates happening from different users. Does anyone
have a script handy for this? thanks


This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page