system table sysmergesubscriptions: replacements for distributor and srvid
-
Hi The system table sysmergesubscriptions has changed from SQL Server 2000 to SQL Server 2005. The columns distributor and srvid are no more available. I have a stored procedure that used this columns that is not working when it should be used on an SQL Server 2005 or 2008. Are there any replacements for this columns and is it possible to use them also on SQL Server 2000? Here is the query that uses this columns:
DECLARE repl_cur CURSOR FOR
SELECT
mp.name,
me.srvname,
mp.publisher,
mp.publisher_db,
ms.db_name,
ms.subscription_type,
ms.distributor
FROM
sysmergepublications mp
INNER JOIN
sysmergesubscriptions ms
ON ms.pubid = mp.pubid
INNER JOIN
master.dbo.sysservers me
ON ms.srvid = me.srvid
INNER JOIN
sysmergearticles ma
ON ma.pubid = ms.pubid
WHERE
ma.name = 'PasswordCounter'
AND ms.subscription_type = 1Thanks for your help Greets Roland
Hi! I'm a signature virus. Copy me into your sig file and help me spread!