One reason could be backing up a perticular file group. SQL Server now alows you to backup a filegroup

In the server Name Ie. Priject Property ->Deployment -> Server Put the Database Server Name and not the Web Server Name. The Default name localhost is s bit misleading.

R...

I have added some more information about this on My Blog , Hope this helps.

R A J

I had a similer issue , I was using Service Broker and was trying to send email after the Job of the Queue was complete. Iwas getting the error...

This was a great artical.

Here is my Experience. In My Previous Job we had a Stored Procedure that used to Take around 6 Hours to Run (Batch JOB)...

This was a good one , Helped me quite a bit.

I will do it when next time it hangs, But My Concern is that It works great through SSMS at the very same time but hangs through the application. My...