Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Replication Expand / Collapse
Author
Message
Posted Wednesday, May 12, 2010 7:34 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 6:53 PM
Points: 31,177, Visits: 15,623
The question has been edited to remove the 2005 choice. It does ask which version of 2008, so that's not a valid answer, but in hindsight that's a little tricky.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #920465
Posted Wednesday, May 12, 2010 8:13 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 12:27 PM
Points: 271, Visits: 380
I want my point :)
Post #920513
Posted Wednesday, May 12, 2010 8:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 8, 2014 11:02 AM
Points: 18, Visits: 661
I would have to agree that the question could have been worded better. But I think it still encouraged people to think a little about replication, how it works, what options are available, and most importantly, which editions of SQL Server each type of replication is available in.
Post #920524
Posted Wednesday, May 12, 2010 8:46 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:54 AM
Points: 17,814, Visits: 15,740
Steve Jones - Editor (5/12/2010)
The question has been edited to remove the 2005 choice. It does ask which version of 2008, so that's not a valid answer, but in hindsight that's a little tricky.


I think the tricky part of the question is that two editions of SQL 2008 support this feature. The source for the answer is reliant on one statement in an msdn article that contradicts itself further down in the article.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #920559
Posted Wednesday, May 12, 2010 9:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
sknox (5/12/2010)The question was good, but had a minor flaw in presentation. Because it was single-choice, and the two relevant choices were Standard and Enterprise edition, all that was required to get a correct answer was the knowledge that Enterprise edition has all of the features of Standard edition and more. Therefore if Standard edition were a correct answer, then Enterprise edition would have to be as well. And if Standard edition were not correct, Enterprise is the only other option. So Enterprise edition has to be a correct answer.


This is actually what I was thinking, that Enterprise had to support it, so there was really no choice.
Post #920627
Posted Wednesday, May 12, 2010 2:23 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, September 12, 2014 2:16 PM
Points: 990, Visits: 2,223
All good stuff is in Enterprise...
This is better link to answer the question (I think):

http://msdn.microsoft.com/en-us/library/cc645993.aspx

--Vadim.
Post #920856
Posted Thursday, May 20, 2010 11:58 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 3:03 AM
Points: 889, Visits: 1,454
Folks,

I guessed it very easily..

P2P replication is a newer arrival to SQL Server 2008 and certainly can't be available with SQL 2008 Standard Edtn. But Option -(3) doesn't look to be good.

Keep posting more interesting queries, dude.

Regards ...


Thanks.
Post #925426
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse