There are some basic steps which can be performed quickly to fix this issue.
just check whether there was any pending transaction in COM
Start MSDTC and then restart SQL server service.
RPC should be running before MSDTC is STARTED.
INTERVIEW PREPARATION IN 30 MINs – Read Following wires for a quick interview preparation.
- SQL Server DBA “Interview Questions And Answers”
- SQL Azure Interview Questions and Answers Part – 1
- SQL Azure Interview Questions and Answers Part – 2
- Powershell Interview Questions and Answers
Online MSSQL Classes @ http://tuitionaffordable.webstarts.com