INSERTS that will STAY after a ROLLBACK is issued

• AFPeterson

  SSCommitted

  Points: 1580

  More actions

  December 12, 2002 at 6:43 am

  #357671

  The SQLServerCentral script 'INSERTS that will STAY after a ROLLBACK is issued ' looks great.

  http://www.sqlservercentral.com/scripts/contributions/498.asp

  But, after trying it on three different servers, version 7 and 2000, and I cannot get the DMO section to work.

  From sp_OAGetErrorInfo

  I get the error:

  OLE Automation Error Information

  Source: Microsoft SQL-DMO

  Description: [SQL-DMO]This server object is not connected.

  @error: -2147211483

  What do I have to do get get connected?

  (Now there's an opening....)

  Thanks, Andrew

  
  What's the business problem you're trying to solve?

• Simon Sabin

  SSCrazy Eights

  Points: 8142

  More actions

  December 12, 2002 at 7:24 am

  #444242

  Have you changed the sa password from the value in the script of SA

  Simon Sabin

  Co-author of SQL Server 2000 XML Distilled

  http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

  
  Simon Sabin
  SQL Server MVP
  
  http://sqlblogcasts.com/blogs/simons

• AFPeterson

  SSCommitted

  Points: 1580

  More actions

  December 12, 2002 at 12:14 pm

  #444281

  Thanks, I missed that at first. But with the correct password, I now get error = 0, but after rollback, the table is empty - no non-logged records.

  
  What's the business problem you're trying to solve?