Error severity 13 indicates what?

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

(Continued from previous question...)

Error severity 13 indicates what?

Answer
Transactional deadlock errors.

Explanation
This level of error severity indicates a transaction deadlock error.

(Continued on next question...)

Other Job Interview Questions

• What port do you need to open on your server firewall to enable named pipes connections?
• You wish to back up the symmetric key used to protect data on the Reporting Services 2005 instance installed on Sales01. From your workstation, what command do you use?
• What does this return?
• True or false, Report Builder offers direct export to a Microsoft Access database as one of its supported export options?
• You want to speed up your SQL Server 2005 Service Broker queue by placing an index on it. What is the best way to do this?
• In SQL Server 2005, if you initialize a subscription using FTP, how is the password sent?
• What format are images rendered in if they were stored originally in another format?
• Which permission in SQL Server 2005 allows you to switch your security context to that of another user with the EXECUTE AS statement?
• To optimize the configuration of tempdb for performance, what setting should be used for the tempdb recovery model?
• How can you quickly determine if any of these indexes are really being used?
• More...