Monday, 10 December 2012

Deprecated Stored Procedures in SQL Server 2008


Like it's predecessor, SQL Server's support came to the end for some of its Stored Procedures of SQL Server 6.5/7.0

Below shown is a list of those procedures........


sp_addalias 
sp_addgroup 
sp_changegroup 
sp_cleanupwebtask 
sp_convertwebtasks 
sp_dbmmonitorMSgetthelatestlsn 
sp_dropgroup 
sp_dropwebtask 
sp_dts_addfolder 
sp_dts_addlogentry 
sp_dts_checkexists 
sp_dts_deletefolder 
sp_dts_deletepackage 
sp_dts_getfolder 
sp_dts_getpackage 
sp_dts_getpackageroles 
sp_dts_listfolders 
sp_dts_listpackages 
sp_dts_putpackage 
sp_dts_renamefolder 
sp_dts_setpackageroles 
sp_enumcodepages 
sp_extended_logging 
sp_fulltext_MasterMergeCheckpointInterval 
sp_fulltext_querytimeout 
sp_getarticlepkcolbitmap 
sp_helpgroup 
sp_makewebtask 
sp_MSCheck_premature_expired_subscriptions 
sp_MScopy_subscription_regkeys 
sp_MSdropreplsymmetrickey 
sp_MSvupgrade_registry_core 
sp_readwebtask 
sp_runwebtask 
spt_procedure_params_managed_view 
spt_procedure_params_return_values_managed_vsyssegments