SQL Server Performance

why xp_makecab is not included in Sql Server 2005?

Discussion in 'SQL Server 2005 General Developer Questions' started by vramos, Jun 18, 2007.

  1. vramos New Member

    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
  2. MohammedU New Member

    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.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    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
    http://www.SQL-Server-Performance.Com
    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.

Share This Page