Error messages in sql server - urgent

[Sangita]

Hi,
Plz can anyone tell me how to get the corresponding error message for the error number indicated by @@error during runtime in stored proc.Sysmessages tables have the error messages,but then i need the actual message that has all parameters embedded in the message found in that table...so plz let me know how to get hold of system error messages during runtime.

THANX
Sangita

 

[Strannik]

What for ? In your client application you can catch any exception and give to user error message supplied my MSSQL.