AnsweredAssumed Answered

MS SQL Server migration 2005 to 2008 - Extended Procedure Issue

Question asked by clarity2689 on Mar 1, 2013
Latest reply on Mar 5, 2013 by Phillip-Owens
Hi All,

We are currently upgrading from ‘MS SQL Server 2005 to MS SQL Server 2008’ as part of CA clarity PPM upgrade from v12.0.6 to V13.1.

We have a question raised by the DBA team that some of the Extended Procedures in few Stored Procedures that exist in the Database MS SQL server 2005 ,obsolete features of these SP will be removed in future versions of MS SQL as per the below link from Microsoft.

http://msdn.microsoft.com/en-in/library/ms175200(v=sql.105).aspx

Ideally these Extended Procedures should be removed from the code of MS SQL 2008. So in such a case how will the CA Clarity PPM upgrade v13.1 handle if the SP’s are not available for the upgrade. Or is this something which needs to be taken care by the DB upgrade.

Some of the Extended Procedures which are removed :

master.dbo.sp_OAGetErrorInfo
master.dbo.sp_OACreate
master.dbo.sp_OAMethod
master.dbo.sp_OAGetProperty

Regards,
Pavithra Manoharan

Outcomes