CLR Deployment Issues

• csadlier

  Grasshopper

  Points: 13

  More actions

  January 26, 2010 at 1:59 pm

  #219976

  I am trying to debug a CLR in Sql Server 2005 written in C#. The problem I am having is that the deploy times out in VS2005 IDE. I have tried using scripts to deploy it but they are not completing either. I have waited for a couple of hours. I have tried to Kill one of the SPIDs but the output says: "SPID 79: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.". It doesn't ever change. I have tried making a new assembly through the UI in Sql Server but it has been running for a half hour. There are about 10 processes trying to deploy the package. How can I determine what the problem is? How can I resolve this issue? It doesn't seem to be slowing down or hanging the server.

  Thanks.

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  January 28, 2010 at 11:12 am

  #1110251

  This is not the correct place to post this question. Try here or here.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/