SQL Server Performance Forum – Threads Archive
About sp_scriptpublicationcustomprocs
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 suggestionthanks in advance
Filson
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 (<column definitions><img src=’/community/emoticons/emotion-5.gif’ alt=’‘ /><br /><br />INSERT INTO #tbl_for_sp<br />EXEC sp_scriptpublicationcustomprocs <whatever parameters you need to use><br />
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
***********************
]]>