What does HAS_DBACCESS() do?

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

(Continued from previous question...)

What does HAS_DBACCESS() do?

Answer: Returns a 1 if the current user has access to the database passed in. Explanation: This function returns a 1 if the current user has access to the database named passed to the function and 0 if they do not. It is a way to check access before changing to that database.

(Continued on next question...)

Other Job Interview Questions

• In SQL Server 2005 T-SQL, what does the CONTINUE statement do?
• In SQL Server 2005 Analysis Services, what does the Synchronize Database Wizard allow you to do?
• You have a relatively new SQL Server 2005 and msdb is corrupt. How can you fix this database without a restore? (data loss is acceptable)
• You want to script the execution of an Integration Services package from the command line for use from a Unix scheduler. What utility would you use?
• What is the difference between a return parameter and an OUTPUT parameter?
• What is the scope of the control permission in SQL Server 2005?
• What does this WHERE clause evaluate to?
• What does this return?
• Can you use a CASE statement in a WHERE clause?
• What does this return?
• More...