What does a @@fetch_status of -2 mean in SQL Ser

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does a @@fetch_status of -2 mean in SQL Server 2005?

Answer
The row being fetched is missing.

Explanation
This means that the row that was being fetched from the cursor is missing.

(Continued on next question...)

Other Job Interview Questions

• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• If you received a "Performance Critical" status in the SQL Server 2005 replication monitor, what does this mean?
• How can SQL Server Agent Mail send messages in SQL Server 2005?
• With SQL Server 2005, Oracle servers can be included in your replication topology. How can an Oracle server function?
• What does @@textsize return?
• In the SQL Server 2005 thesaurus XML configuration file, what is the expansion set?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• What is the quickest way to get them working?
• How many rows are returned by these two select statements?
• Which of the following datatypes can be represented in a SQL_VARIANT datatype?
• More...