sysadmins

Question

sysadmins

Steve Jones - SSC Editor

SSC Guru

Points: 738140
More actions
November 21, 2013 at 8:19 pm

#72501

Comments posted to this topic are about the item sysadmins

Viewing 15 posts - 1 through 15 (of 17 total)

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

Koen Verbeeck SSC Guru Points: 259165 More actions · Answer 1

Nice one, thanks.

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

Richard Warr SSCertifiable Points: 6968 More actions · Answer 2

I knew doing that 70-462 would come in handy one day.

Interesting that over 40% of answers are for a DMV that doesn't even exist :blink:

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 3

Beatrix Kiddo

SSC-Dedicated

Points: 32407

November 22, 2013 at 3:55 am

#1668345

Phew, got it right!

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

I'm still on 2008, so I went with what I knew. It's good to see they didn't change it in 2012.

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

Beatrix Kiddo SSC-Dedicated Points: 32407 More actions · Answer 5

Beatrix Kiddo

SSC-Dedicated

Points: 32407

November 22, 2013 at 5:39 am

#1668367

Same here, Ed!

steve.jacobs SSCommitted Points: 1830 More actions · Answer 6

steve.jacobs

SSCommitted

Points: 1830

November 22, 2013 at 6:15 am

#1668380

Excellent question for a Friday.

Thanks

Thomas Abraham SSChampion Points: 10761 More actions · Answer 7

Nice question!

Here's a useful SQL Server Script to list database name, login type, server login name,server role, database user and database role[/url] I found.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Dana Medley SSCertifiable Points: 6764 More actions · Answer 8

Ed Wagner (11/22/2013)
I'm still on 2008, so I went with what I knew. It's good to see they didn't change it in 2012.

+1 Thanks for the great question!

Everything is awesome!

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

Revenant

SSC-Forever

Points: 42467

November 22, 2013 at 12:56 pm

#1668518

Thanks, Steve, and have a great weekend!

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

Thanks for the easy question!

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 11

PChiragS

SSCarpal Tunnel

Points: 4965

November 23, 2013 at 9:12 am

#1668597

Nice question..

TomThomson SSC Guru Points: 104773 More actions · Answer 12

Nice question.

But 27% wrong answers! (242 out of 520). That's pretty amazing. Nearly half the people who replied don't know that security princials are listed in the sys.server_principals DMV (most of them preferring a non-existent DMV).

Tom

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 13

nice Q, thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective

darkhelmutis SSCommitted Points: 1561 More actions · Answer 14

Technically speaking the answer to the question should be 'None of the above', sys.server_principals is NOT a DMV, it is Catalog View.

sysadmins

Cookies on SQLServerCentral