SQL Server Errors Question:

What is sqlcode -922 & -923?

Answer:

Reason why SQLcode -922 generated:

Authorization failed because of the error indicated by error-type

It can be any of the following..

* User authorization.
* Plan access
* connect
* Installation error
* Duplicate exit requested.

Reason code: DB2® reason code associated with authorization failure

Download SQLServer Errors PDF Read All 10 SQLServer Errors Questions

Previous Question	Next Question
In one table there is 10 records without id num, without primary key and it is not sorted then how to extract last 6 record from table?	How to select particular number using rownum? Example: i need only the second max number using rownum?