DBA > Job Interview Questions > Microsoft SQL Server FAQs

What happens when a transaction fails on the pub

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

(Continued from previous question...)

What happens when a transaction fails on the publisher?

If you have a replication scenario with one publisher, one distributor and one subscriber and the transaction isolation level is not set to serializable, what happens when a transaction fails on the publisher?
Native Web Services require what type of endpoint in SQL Server 2005?

Answer
HTTP endpoints
Explanation
Native XML Web Services in SQL Server 2005 require HTTP endpoints to communicate with clients.

(Continued on next question...)

Other Job Interview Questions