why xp_makecab is not included in Sql Server 2005? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

why xp_makecab is not included in Sql Server 2005?

Does anyone know why xp_makecab is not included as extended stored procedure in Sql Server 2005? It works perfect in Sql Server 2000, and now I have an issue in Sql server 2005.
Is there any other xp that replaced xp_makecab? I would really appreciate any help in this matter
It was undocumented and this procedure still exists but in resource database which is not accessible for regular use… unless you use DAC option… xp-makecab procedure used in master..sp_copysubscription procedure…Just run the helptext you can see the code… MohammedU.
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=154 – purpose of Surface Area Configuration tool and in this case you might need to test the implication before deploying in production. This is the one of the reasons you should not use undocumented stored procedures or XPs, as they tend to drop or even change in behaviour how it works. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.