Good article, CMS is a very useful tool. Administration can be even simpler when you see that there are only actually two tables that define whole of CMS and you...

Running through the MS post (http://support.microsoft.com/kb/2509302) removed the tran_sp_MScreate_peer_tables tran from dbcc opentran and I was then able to shrink the transaction log. I'd still be interested if anyone has...

What thread were you referring to? It does sound like good news 🙂

I think the problem may arise when trying to apply the SP to the passive node rather than the active node, which is how we have been doing it. This...

We upgraded last week to SP3 and lo behold the same problem occurred. MS have now posted a resolution on 22nd Sept: http://support.microsoft.com/kb/2509302. We are going to run through this...

It is also worth noting that you will lose all indexes (and statistics) on the subscription database bar primary keys after reinitialising, I am just recreating from a back up...

Fixed!!

I fixed this in two steps:

1) Recent upgrade to SP2 did not install correctly on one of the nodes as the registry value from link was 0, working through the...

Thanks both for your help, very useful. sys.databases showed as ACTIVE_TRANSACTION, so I ran DBCC OPENTRAN which showed this:

Oldest active transaction:

SPID (server process ID): 7s

...

It is worth noting that this program will only work on SQL 2000 which is a shame

http://www.red-gate.com/messageboard/viewtopic.php?t=4335&postdays=0&postorder=asc&start=15

You can use this method in a view but you need to put your lookup query into a function (unique id as input, returns varchar) then use the function in...

Hi Mark, two possible example scenarios:

1) You want to show data in one column that may be held in multiple rows on another table

emp id; emp name; manager(s)

1;Sally; Jack, John,...

That would definitely come in useful when extracting data from SQL, each data item could be 1000 characters in which case you would only need 8 rows before you start...

Jason, the method described does not use a cursor. It is good to share the method in the article but it should be known and in use already which judging...

For anyone looking for a working solution I am using the code below on a 64 bit SQL 2008 server. Thanks Steve for the push in the right direction.

My SSIS...

I have just found the area where the bug arises. What I had been doing was running the following steps:

REMOVE TABLE FROM REP USING

exec sp_dropsubscription ...