Hi,
SQL 2000 SP3.
I am trying to capture not just an error number (like set @err = @@error) but the message also. I know I can get the message from sysmessages table but it's not very descriptive because it has a lot of placeholders that are being 'filled' at runtime.
I am pretty sure it's not difficult just does not seem I am finding the way to do this!
Thank you,
Julia