6.5 replication migration to 2K

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

6.5 replication migration to 2K

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-13 : 08:39:58

justin writes "Hello SQL Team,

I have a query that I need help with; I have lovingly crafted a script that flushes the contents of a SQL server 6.5 sp5a distribution database of all pending transactions, to be used in the case that someone sends an erroneous command to the publishing DB (I have set a 30 min delay on commit to Subscriber, so I can catch such a problem).
Below is an excerpt from the script:

use $DIST_NAME # (in this case hermes_distribution)

declare @MAX_JOB_ID INT

declare @MAX_SUBSTAT_ID INT

select @MAX_JOB_ID=max(job_id) from msjobs

select @MAX_SUBSTAT_ID=max(job_id) from mssubscriber_status

update mssubscriber_status set job_id=@MAX_JOB_ID where job_id=@MAX_SUBSTAT_ID

use $HERMES_DB

update MSlast_job_info set job_id=@MAX_JOB_ID

What I have found is that in SQL 2000 sp1, the msjobs, mssubscriber_status, and MSlast_job_info tables are no longer present. I think I have found the msjobs, now MSrepl_commands?, but the others elude me. Can you help me resolve all of these table names in SQL 2000?

Thanks and regards,

J>

Justin Noreikis
UNISYS
Media Systems Architecture
Via Benigno Crespi, 57 - 20159 Milano - Italy
+39 02 6985 435
Net 765 4435

Privileged/Confidential Information may be contained in this message.
If you are not the addressee indicated in this message (or responsible for delivery of
the message to said person), you may not copy or deliver this message to any other parties."

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources