SQL Server Performance

About sp_scriptpublicationcustomprocs

Discussion in 'Performance Tuning for SQL Server Replication' started by filson, Sep 18, 2006.

  1. filson New Member

    How i can store sp_scriptpublicationcustomprocs result in one file.because if i am running sp_scriptpublicationcustomprocs in query analyser and copying the result means i am missing something because of row length.give me some better suggestion
    thanks in advance
  2. Adriaan New Member

    Does it return a single resultset, or more than one?<br /><br />If just one resultset is returned, then you can use this syntax:<br /><br />CREATE #tbl_for_sp (&lt;column definitions&gt<img src='/community/emoticons/emotion-5.gif' alt=';)' /><br /><br />INSERT INTO #tbl_for_sp<br />EXEC sp_scriptpublicationcustomprocs &lt;whatever parameters you need to use&gt;<br />
  3. ndinakar Member

    you can set the results to text and increase column count to around 1200 and open up the text file from subscriber. Make sure the column count in subscriber query analyzer is also set to 1200.

    Dinakar Nethi
    SQL Server MVP

Share This Page