(Continued from previous part...)

Error severity 13 indicates what?

Answer
Transactional deadlock errors.

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

In which order do you perform an upgrade to SQL Server 2005 for replicated databases?

Answer
Distributor, Publisher, then Subscriber.

Explanation
You always perform an upgrade in this order: distributor, publisher, subscriber.

How many Service Packs will be released for SQL Server 2005 in 2007?

Answer:
Explanation: The answer is up in the air and this is more of a poll than a real QOD. Based on the ways things are going, the staff here sees just 1, though our hope would be that 3 or 4 would be released.

You setup a linked server from a SQL Server 2000 server to your new SQL Server 2005 server (with defaults), however you cannot execute procedures on the 2005 server. Why not?

Answer:You need to enable RPC.

Explanation: By default, RPC is disabled in SQL Server 2005. You need to set the "remote access option" in your server configuration to 1 to allow the execution of stored procedures from a remote server.

What is the recommended way to send mail from SQLAgent in SQL Server 2005?

Answer: Database Mail

Explanation: You can use either Database Mail or SQLMail with SQL Agent in SQL Server 2005. However since SQLMail will be removed, it is recommended that you use Database Mail.

When you create a new Message Type in the SQL Server 2005 Service Broker, what does the Authorization parameter signify?

Answer: The owner of the message type.

Explanation: This parameter determines the owner of the message type. This defaults to the current user.

What the heck does ATN2 do?

Answer: The angle between the x-axis and a ray.

Explanation: This is a mathematical function that returns the angle between the positive x-axis and the ray that passes through the two coordinates passed in. The angle is in radians.

(Continued on next part...)