Hi everybody
Im using MSDE Rel A and ive installed the client tools from the SQLserver2k demo and im only on my 5th day of playing with SQLserver, its v cool :)

I have a trigger which should print a message like

print 'name of "' + @oldName + '" changed to "' + @newName + '"'

however when i run an update in the query analyzer the only message i recieve is the new name.

does anybody know where im going wrong?

What is there in @oldName and how does it get the value assigned to it? Hope posting some more code on that would help to find what you are missing.

Cheers!

_________________________
- Vijay G
Strive for Perfection