Yes they are, and the database is in 80 compatibility mode.

-----Original Message-----
From: McCarter
[mailto:mssqldba-ezmlmshield-x37979768.[Email address protected]
Sent: Wednesday, April 30, 2008 3:10 PM
To: LazyDBA Discussion
Subject: Triggers

Hi experts,
If we move a database from SQL 2000 to SQL 2005, by doing a restore to
the SQL 2005, will the triggers be restored to the SQL 2005 environment?
Thanks,
Richard



---------------------------------------------------------------------
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



-----------------------------------------
The information contained in this e-mail message is intended only
for the personal and confidential use of the recipient(s) named
above. This message may be an attorney-client communication and/or
work product and as such is privileged and confidential. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are
hereby notified that you have received this document in error and
that any review, dissemination, distribution, or copying of this
message is strictly prohibited. If you have received this
communication in error, please notify us immediately by e-mail, and
delete the original message.

MS Sql Server LazyDBA home page