July 8, 2009 at 8:16 am
I have a stored procedure that creates log entries during a data warehouse load that don't get rolled back if the load fails (and rolls back) by using SQL-DMO to connect back in to the SQL Server and therefore put the entry outside the scope of the transaction.
The object is created here:
EXEC sp_OACreate 'SQLDMO.SQLServer', @oSQLServer OUT
I've migrated the warehouse from SQL Server 2000 to 2008 and this is now returning NULL, presumably because SQL-DMO is no longer implemented.
Is there an alternative to use in place of SQLDMO.SQLServer that behaves in the same way?
If not, can I just install SQL-DMO on the server and be done with it?
June 18, 2010 at 6:31 am
I have the same problem. Did you find a solution?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy