mssql_min_error_severity

Synopsis

Returns

Void

Description

Sets the minimum level at which errors will be displayed. Microsoft SQL Server has two sets of error-reporting functionality. The first reports error levels that relate to errors inside the server itself. In addition, these error levels can be generated programmatically by the user. The other error functionality relates to server messages, and this is handled by the mssql_min_message_severity() function. A good demonstration of this is to set both mssql_min_error_severity() and mssql_min_message_severity() to 1, then attempt to log in using an incorrect username or password. Microsoft SQL Server will report back both a message and an error. The message has a severity level of 14, while the error has a severity level of 2. In both cases, they indicate a user error. More information on these error levels can be found in the Microsoft SQL Server documentation.

This value can also be set in the PHP initialization file.

Example

mssql_min_error_severity(3);
mssql_min_message_severity(17);
$db=mssql_connect("server","sa","wrongpassword") or die("mssql_get_last_message());