<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Steve Jones
»
Service Service Accounts
30 posts, Page 1 of 3
1
2
3
»
»»
Service Service Accounts
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, February 23, 2012 8:43 PM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436,
Visits: 13,751
Comments posted to this topic are about the item
Service Service Accounts
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1257073
baabhu
baabhu
Posted Thursday, February 23, 2012 8:49 PM
Ten Centuries
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:58 AM
Points: 1,112,
Visits: 970
Wow. I did not knew there are DMV's to see the Service accounts.
Good to knew it.
Very good question.
Post #1257075
Henrico Bekker
Henrico Bekker
Posted Thursday, February 23, 2012 8:57 PM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:24 AM
Points: 1,871,
Visits: 2,692
Your answer states:
Correct answer:
Query
sys.dm_service_services
, Query sys.dm_server_registry
Explanation:
After SP1 for SQL Server 2008 R2, there is a new DMV that allows you to query for the service accounts used for the various SQL Server services. You can also use the
sys.dm_server_registry DMV
to find the information, although this is not as clean.
Ref:
dm_server_services - http://msdn.microsoft.com/en-us/library/hh204542.aspx
sys.dm_server_registry - http://msdn.microsoft.com/en-us/library/hh204561.aspx
see the problem?
----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1257079
Kameswari Aravindh
Kameswari Aravindh
Posted Thursday, February 23, 2012 11:55 PM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 09, 2012 3:46 AM
Points: 2,223,
Visits: 177
The Option specified is wrong it is not Sys.dm_service_services but it is Sys.dm_server_services.
I got my question wrong because of this.
Post #1257133
palotaiarpad
palotaiarpad
Posted Friday, February 24, 2012 12:20 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 12:06 AM
Points: 849,
Visits: 323
Please correct the typo!
Post #1257152
JanR
JanR
Posted Friday, February 24, 2012 12:22 AM
Ten Centuries
Group: General Forum Members
Last Login: Monday, April 08, 2013 4:09 AM
Points: 1,088,
Visits: 114
Why you can't prepare task correctly?
My answer was right compared to prepared options.
Post #1257155
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Friday, February 24, 2012 12:29 AM
Hall of Fame
Group: General Forum Members
Last Login: 2 days ago @ 8:31 AM
Points: 3,129,
Visits: 4,312
I did not know about the dm_server_services DMV, so I learned something here, thanks , Steve.
Knowing this would have saved me a fair headache a few days ago.
Point of note: tringer fouble causes endless trouble....
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1257160
Koen Verbeeck
Koen Verbeeck
Posted Friday, February 24, 2012 12:54 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 2:11 AM
Points: 9,378,
Visits: 6,473
Very interesting question, as I don't have SP1 installed yet on our server.
Luckily I guessed the intent of the question and realised that the first answer was a typo.
Let the flame wars begin!
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1257172
Mighty
Mighty
Posted Friday, February 24, 2012 1:20 AM
SSCrazy
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 8:33 AM
Points: 2,723,
Visits: 987
Learnt something new from the question, which was good.
Selected the only one correct answer, leaving out the other "correct" option. No points.
Post #1257184
Konstantin Reu
Konstantin Reu
Posted Friday, February 24, 2012 1:24 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:15 AM
Points: 1,882,
Visits: 426
good query about new DMV in SP1.
But change wrong first item sys.dm_service_services to sys.dm_server_services
is needed
MCTS х 3
MCITP x 2
MCSA x 1
Post #1257188
« Prev Topic
|
Next Topic »
30 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
