"William Wang[MSFT]" <v-rxwang@online.microsoft.com> wrote in message
news:rCbc$UynFHA.3672@TK2MSFTNGXA01.phx.gbl...
> Hi Ian,
>
> Can you post the detailed text of the error message? This is important to
> get a clue of what has happened. In addition, please provide detailed
> information of your replication scenario as mentioned in the following
> article:
>
> INF: Information that PSS needs to troubleshoot SQL Server replication
> http://support.microsoft.com/?id=315642
>
> Also I recommend that you install SQL2K SP4 to see if the issue still
> exists.
>
> Sincerely,
>
> William Wang
> Microsoft Online Partner Support
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>

"Paul Ibison" <Paul.Ibison@Pygmalion.Com> wrote in message
news:%23wYm2wjoFHA.3568@TK2MSFTNGP10.phx.gbl...
> Continuing from William's advice, if anyone is interested in a simple way
of
> achieving this, have a look at this script which can be run in a DTS job:
>
> '**********************************************************************
> ' Visual Basic ActiveX Script
> '************************************************************************
>
> Function Main()
>
> Dim objDMO
> Dim objReplication
> Dim fso
> Dim tf
>
> Set objDMO = CreateObject("SQLDMO.SQLServer")
> Set fso = CreateObject("Scripting.FileSystemObject")
>
> objDMO.LoginSecure = True
> objDMO.Connect "crazyfrog"
> Set objReplication = objDMO.Replication
>
> Set fso = CreateObject("Scripting.FileSystemObject")
> Set tf = fso.CreateTextFile("c:\testfile.txt", True)
>
> tf.Write objReplication.Script(1048576)
> tf.Close
>
> Main = DTSTaskExecResult_Success
>
> End Function
>
> (http://www.replicationanswers.com/Script7.asp)
>
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>