We have a trigger which emails selected users once an update is performed on a particular column of a selected table. We recently moved the datbase to a new server. The database originally resided on a WIN NT / SQL 7 and is now on WIN 2K / SQL 7. Security, rights and users are exactly the same on the new server but the trigger executes but locks the table and fails to complete the update or send the email. It stays in the locked status and we must reboot the server to kill the process(it does not perform the update). Why would the trigger lock the table and freeze? If security is the same what else could be wrong?????? .dll's???
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TRIGGER
- Thread starter jrc1
- Start date
arrowhouse
MIS
How are you emailing? are you using SQL mail? If so, has this been set up & is it running ok
- Thread starter
- #3
- Status
