mysql_error() + SQL Server

[obrienkev]

Hi all,

What are the equivalent functions in mssql of mysql_errno() & mysql_error()???

Thanks.

[cflorinel]

you could try running the following queries:

SELECT @@ERROR AS error_code

SELECT 
	cast (description as varchar(255)) 
AS 
	err_description
FROM 
	master.dbo.sysmessages 
WHERE 
	error = ERROR_CODE_HERE

alos you can try using: mssql_get_last_message() .