SQL Server Express DAC

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » SQLServerCentral.com Announcements » SQL Server Express DAC

37 posts, Page 1 of 4

1 2 3 4 »»»

SQL Server Express DAC

Rate Topic

Display Mode

Topic Options

Author

Message

Site Owners

Posted Wednesday, April 23, 2008 8:42 PM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

Comments posted to this topic are about the item SQL Server Express DAC

Post #489656

Jan Van der Eecken

Posted Thursday, April 24, 2008 1:23 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 7:15 AM
Points: 2,260, Visits: 5,931

Sorry, but I don't agree with the "correct" answer to the QotD. If one asks whether SQL Express allows DAC BY DEFAULT, then the answer should be a resounding NO! Starting the server with trace flag 7806 can hardly be described as a default.

Regards,
Jan

--------------------------------------------------------------------------

The function of good software is to make the complex appear to be simple. (Grady Booch)

Post #489704

Daniel Schmitz

Posted Thursday, April 24, 2008 2:09 AM

Ten Centuries

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 1:46 AM
Points: 1,003, Visits: 210

I agree with Jan.

Regards
Daniel

Post #489714

RichardWalters

Posted Thursday, April 24, 2008 2:24 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, December 07, 2009 12:39 PM
Points: 297, Visits: 531

let me add my name to the list of dissenters!

Post #489720

JKG

Posted Thursday, April 24, 2008 2:36 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 16, 2013 4:23 PM
Points: 421, Visits: 710

The only possible answers to this are 'yes' and 'no'. Something is either the default or it isn't.

Post #489723

Ben Leighton

Posted Thursday, April 24, 2008 2:37 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 05, 2011 8:18 AM
Points: 582, Visits: 359

Count me in with the dissenters... shall I get my pitchfork?

Post #489725

rajankjohn

Posted Thursday, April 24, 2008 3:14 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, February 15, 2013 2:53 PM
Points: 1,199, Visits: 568

well...the "default" is the cuprit this time :)
http://rajanjohn.blogspot.com/

Post #489738

WilliamD-

Posted Thursday, April 24, 2008 4:18 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 7:34 AM
Points: 449, Visits: 1,770

Count me in too.

Default is no, if I have to add a flag to the server startup parameters it is NOT default Ermm

I want my point for getting it right! ;)

Regards,

WilliamD

Post #489772

Derek Dongray

Posted Thursday, April 24, 2008 4:19 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, May 13, 2013 2:04 AM
Points: 1,342, Visits: 1,946

I agree with the people who say that "by default" only allows answers "yes" or "no", but by giving 2 other options, I think most people would ignore the prefix and read the question as "Does SQL Server 2005 Express allow Dedicated Administrator Connections (DAC)?". In which case, the answers are valid.

Derek

Post #489773

Ignacio A. Salom Rangel

Posted Thursday, April 24, 2008 5:23 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, May 10, 2013 2:49 PM
Points: 3,051, Visits: 1,356

I join the dissenters.

My blog

Post #489805

« Prev Topic | Next Topic »

37 posts, Page 1 of 4

1 2 3 4 »»»

Permissions