We have been provided a new update trigger by our software vendor and it includes 'SELECT * FROM updated'. When the table this trigger runs on gets updated it produces an error 'Invalid object name updated'. I have heard of the virtual tables inserted and deleted but never updated.
Can someone please confirm that updated is not a viable option for an update trigger before I go back to the vendor and make an arse of myself?
Cheers,
Blair