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 1234»»»

SQL Server Express DAC Expand / Collapse
Author
Message
Posted Wednesday, April 23, 2008 8:42 PM
SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,039, Visits: 1
Comments posted to this topic are about the item SQL Server Express DAC
Post #489656
Posted Thursday, April 24, 2008 1:23 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, November 6, 2014 5:01 AM
Points: 2,116, Visits: 6,441
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


--------------------------------------------------------------------------
A little knowledge is a dangerous thing (Alexander Pope)

In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)
Post #489704
Posted Thursday, April 24, 2008 2:09 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:35 AM
Points: 1,003, Visits: 236
I agree with Jan.

Regards
Daniel
Post #489714
Posted Thursday, April 24, 2008 2:24 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, December 7, 2009 12:39 PM
Points: 297, Visits: 531
let me add my name to the list of dissenters!


Post #489720
Posted Thursday, April 24, 2008 2:36 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 11:42 PM
Points: 449, Visits: 885
The only possible answers to this are 'yes' and 'no'. Something is either the default or it isn't.
Post #489723
Posted Thursday, April 24, 2008 2:37 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, July 5, 2011 8:18 AM
Points: 582, Visits: 359
Count me in with the dissenters... shall I get my pitchfork?
Post #489725
Posted Thursday, April 24, 2008 3:14 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 10:36 AM
Points: 1,199, Visits: 574
well...the "default" is the cuprit this time :)
http://rajanjohn.blogspot.com/

Post #489738
Posted Thursday, April 24, 2008 4:18 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 1:10 AM
Points: 449, Visits: 1,868
Count me in too.

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

I want my point for getting it right! ;)



Regards,

WilliamD
Post #489772
Posted Thursday, April 24, 2008 4:19 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, December 11, 2014 3:10 AM
Points: 1,274, Visits: 1,987
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
Posted Thursday, April 24, 2008 5:23 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, November 5, 2014 3:47 PM
Points: 3,087, Visits: 1,437
I join the dissenters.




My blog
Post #489805
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse