What does the DEALLOCATE statement do in SQL Ser

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

(Continued from previous question...)

What does the DEALLOCATE statement do in SQL Server 2005?

Answer
Remove a reference to a cursor.
Explanation
This statement is used to remove cursor references. If this is the last reference being removed, the cursor's resources are released.

(Continued on next question...)

Other Job Interview Questions

• What is the quickest way to get them working?
• What's the difference between a server login and a database user?
• What is the maximum number of instances of Analysis Services 2005 can be installed on a server?
• What would happen when you execute the code below in Query Analyzer (SQL Server 2000) Submitted by Jacek Osuchowski...
• Can a contained in SQL Server 2005 Integration Services enlist in a transaction started by a sibling container?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• Which collation is used for Service Broker messages sent between the instances?
• In SQL Server 2005 T-SQL, what does the CONTINUE statement do?
• you want to be sure that SQL authenticated logins must abide by the password policy.. .
• Which protocols support Kerberos authentication on SQL Server 2005?
• More...