Using the DAC

Question

Using the DAC

Steve Jones - SSC Editor

SSC Guru

Points: 736478
More actions
November 12, 2016 at 4:22 pm

#72658

Comments posted to this topic are about the item Using the DAC
November 14, 2016 at 1:08 am

This was removed by the editor as SPAM

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

TomThomson SSC Guru Points: 104773 More actions · Answer 1

Nice question. But I hope I never need the answer.

Despite that hope I was horrified to see that 2 or the first 4 answers were wrong - anyone with responsability for databases should know the answer (and hope they never need it).

Interesting that "admin:" (as in the explanation) is what BOL says it is, while the answer offered is "ADMIN:" - I guess SSMS is case insensitive for this so it doesn't matter, but...

Tom

Mighty SSCrazy Eights Points: 9063 More actions · Answer 2

I had the right answer, but was doubting, since the question specifically mentioned SSMS 2016.x.

As far as I know this is already possible since SSMS 2008 (R2).

Ed Wagner SSC Guru Points: 287026 More actions · Answer 3

Good question because I learned something new. I just hope I remember it when we get to use SQL 2016, which will probably be around 2020 or so. 😉

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 4

Ed Wagner (11/14/2016)
Good question because I learned something new. I just hope I remember it when we get to use SQL 2016, which will probably be around 2020 or so. 😉

You shouldn't be viewing this question that way.

SSMS 2016 (which is v16.x) is decoupled from SQL Server. You can download and use SSMS 2016 without being on SQL Server 2016. It's free and on it's own, monthly release cycle.

https://msdn.microsoft.com/en-us/library/mt238290.aspx

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

Steve Jones - SSC Editor (11/14/2016)
Ed Wagner (11/14/2016)
Good question because I learned something new. I just hope I remember it when we get to use SQL 2016, which will probably be around 2020 or so. 😉
You shouldn't be viewing this question that way.
SSMS 2016 (which is v16.x) is decoupled from SQL Server. You can download and use SSMS 2016 without being on SQL Server 2016. It's free and on it's own, monthly release cycle.
https://msdn.microsoft.com/en-us/library/mt238290.aspx

Touche. I do know they're separate products. I tend to stick with SSMS that's the most recent version of SQL Server I have installed. Maybe it's time I examine that decision.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

BillLudlow SSCertifiable Points: 6553 More actions · Answer 6

Isn't DAC connection on previous versions only available via sqlcmd rather than SSMS?

Revenant SSC-Forever Points: 42467 More actions · Answer 7

I also had to consult BoL - I am a dev, not an admin. Thanks, Steve!

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP