What does @@options return?

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

(Continued from previous question...)

What does @@options return?

Answer
The current SET options for the connection.
Explanation
The @@options variable returns a list of the options set for the current connection. This is returned as integer and each bit in the integer represents an option.

(Continued on next question...)

Other Job Interview Questions

• What the heck does ATN2 do?
• How can you determine which user is executing statements in Profiler?
• What does NULL mean?
• What does the CEILING() function do?
• Which commands are allowed when the "Ad Hoc Distributed Queries" server option is set to 0 in SQL Server 2005?
• After you've completed a backup for your Sales server to disk...
• You have upgraded your SQL Server 2000 on Windows 2000 server to SQL Server 2005 to take advantage ...
• In SQL Server 2005 Full-Text Search, you set up a replacement set like this...
• What result would you expect from this statement? Select * from dbo .MyTable
• You are using SQL Server 2005 and you wish to find a number of details about stored procedures created...
• More...