sp_OACreate

• Edward-445599

  Hall of Fame

  Points: 3147

  More actions

  October 5, 2011 at 8:10 am

  #246077

  Hi,

  I have just backed up and restored a DB to a diffrent server (both SQL 2008 R2 sp1 x64 dev) and I have noticed a scipt is failing. On the orginal server sp_OACreate 'SQLDMO.SQLServer' generates a number on the new server it returns a null. I have no idea why.

  DECLARE @object int

  DECLARE @hr int

  EXEC @hr = sp_OACreate 'SQLDMO.SQLServer', @object OUT

  print @object

  Many thanks

• Edward-445599

  Hall of Fame

  Points: 3147

  More actions

  October 5, 2011 at 8:48 am

  #1390730

  its the SQLDMO which is the problem

  Install Microsoft SQL Server 2005 Backward Compatibility Components (if you have to)

  Or even better use SQL Server Management Objects (SMO)