Viewing 15 posts - 1 through 15 (of 30 total)
Update: We found that setting specific SPNs to our server allowed us to connect to it from our office location.
June 6, 2018 at 2:34 pm
Hi Grant, thank you for the reply I appreciate it. I really did try my best to thoroughly document my experience. I said in my first post that I...
November 11, 2014 at 5:03 pm
I want to put a final note on here in case someone comes across this in the future. I researched the min_xact_seqno number that wasn't returning any rows in...
October 22, 2014 at 2:33 pm
Let me start with a simpler question, should the cleanup job be removing records from the MSrepl_commands table, or should that table just grow?
October 16, 2014 at 1:54 pm
Digging into this more, I see that the exec dbo.sp_MSmaximum_cleanup_seqno call isn't returning a @max_cleanup_xact_seqno record.
This means the query
select top 1 @max_cleanup_xact_seqno = xact_seqno
from...
October 10, 2014 at 12:32 pm
Eric Zierdt (10/9/2014)
October 9, 2014 at 2:15 pm
I could start a new post for this, but since a lot of work has been done in this thread, I think I'm going to reply to this thread. ...
October 9, 2014 at 11:57 am
awesome tip. I just started playing with this; i there a parameter that can be set in the config file to do this at install?
As long as I'm asking,...
March 25, 2013 at 1:23 pm
John Morrelles-204026 (7/1/2008)
Existing linked servers will not pick up the provider setting, so new linked server objects will have to be created. But the new ones work.
Ah, that was my...
March 14, 2012 at 8:33 am
I know this is an older topic, but I'd be interested in seeing how other people do this for larger tables. I often need to do this for multi...
October 4, 2011 at 9:36 am
Just saw this thread, I've encountered this problem on my staging server (not clustered) and today on my production server (clustered). For the record, both servers are 2008 R2....
June 30, 2011 at 8:01 am
Just wanted to send a followup, after a week of running the changes, we haven't gotten a new duplicate.
Thanks all!!!
April 1, 2010 at 10:42 am
We implemented the change this morning, I'll be monitoring throughout the day.
Thanks again.
March 26, 2010 at 8:33 am
Paul White NZ (3/25/2010)
This has been gone over many times, but one blog entry that springs to mind is the following one by Alex Kuznetsov: http://sqlblog.com/blogs/alexander_kuznetsov/archive/2010/01/12/t-sql-tuesday-002-patterns-that-do-not-work-as-expected.aspx. ...
March 25, 2010 at 7:20 am
The Dixie Flatline (3/24/2010)
March 24, 2010 at 9:26 pm
Viewing 15 posts - 1 through 15 (of 30 total)