drop temp obj failed serializing drops

• Minto Minto(quendans)

  SSCrazy

  Points: 2533

  More actions

  October 12, 2010 at 11:50 pm

  #241537

  Hi ,

  we are using sql server 2008 R2,standard edition.

  Two days back we got one mesage like

  ............****Drop temp obj failed serializing drops****...........

  After this occurance we are not able to connect database through application.Through ssms also we are not able to connect database.

  After some time we restarted the service.Then we were able to connect database.

  Yesterday also same mesage came.Again we did same processes..

  Can anyone help what is the exact root cause and how to solve this.......

  Thanks in advance.....

• RichardDouglas

  SSCarpal Tunnel

  Points: 4029

  More actions

  October 14, 2010 at 6:57 am

  #1236809

  It looks like you're already receiving some good help here

  Hope this helps,
  Rich

  [p]
  [/p]