Viewing 15 posts - 1 through 15 (of 16 total)
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...
August 18, 2014 at 1:49 am
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...
December 6, 2011 at 6:58 am
What thread were you referring to? It does sound like good news 🙂
December 5, 2011 at 7:15 am
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...
December 5, 2011 at 4:42 am
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...
December 5, 2011 at 3:39 am
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...
July 22, 2011 at 2:51 am
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...
July 19, 2011 at 8:43 am
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
July 17, 2011 at 3:33 am
It is worth noting that this program will only work on SQL 2000 which is a shame
July 13, 2011 at 3:28 am
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...
March 21, 2011 at 5:10 am
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,...
March 21, 2011 at 4:38 am
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...
March 21, 2011 at 3:53 am
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...
March 21, 2011 at 3:40 am
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.
January 20, 2011 at 7:46 am
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 ...
July 15, 2010 at 9:34 am