How to get the latest MS SQL Server error message?

Question

I know:

SELECT @@ERROR 

but this will only give me the ERROR CODE (number), and I need a full text message, for example:

Cannot insert duplicate key string into object 'dbo.TABLE_NAME' with unique index 'IX_ID_unique'.

The statement is complete.

How to do it in MS Sql Server 2005?

EDIT: I need to get this error message on Linux and Windows platforms.

Answer 1

How about ERROR_MESSAGE

See also: Getting Error Information in Transact-SQL

And, with PHP (as your question is tagged php ), take a look at:

• mssql_get_last_message
• PDO::errorInfo

Depending on the API that you use to access the MS SQL Server database, of course.

Answer 2

With the sqlsrv extension module, you can use sqlsrv_errors ([int $ errorsAndOrWarnings]) .