February 23, 2012 at 8:44 pm
Comments posted to this topic are about the item Service Service Accounts
February 23, 2012 at 8:49 pm
Wow. I did not knew there are DMV's to see the Service accounts.
Good to knew it.
Very good question.
February 23, 2012 at 8:57 pm
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%5B/b%5D
sys.dm_server_registry - http://msdn.microsoft.com/en-us/library/hh204561.aspx%5B/quote%5D
see the problem?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2012 at 11:55 pm
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.
:w00t:
February 24, 2012 at 12:20 am
Please correct the typo!
February 24, 2012 at 12:22 am
Why you can't prepare task correctly?
My answer was right compared to prepared options.
February 24, 2012 at 12:29 am
This was removed by the editor as SPAM
February 24, 2012 at 12:54 am
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! 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 24, 2012 at 1:20 am
Learnt something new from the question, which was good.
Selected the only one correct answer, leaving out the other "correct" option. No points.
February 24, 2012 at 1:24 am
good query about new DMV in SP1.
But change wrong first item sys.dm_service_services to sys.dm_server_services
is needed:-)
MS SQL 2008 MCITP x 3
MS SQL 2012 MCSE x 2
February 24, 2012 at 2:10 am
Nice question
I knew it wasnt in dm_os_nodes or dm_os_windows_info, so as it says to pick two, it had to be the top two.
Changed the top one to sys.dm_ser then let intellisence figure the rest out and just confirm, suppose there is a use for intellisence after all.
February 24, 2012 at 2:39 am
SQL Version
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
but when I query these two objects - Query sys.dm_service_services, Query sys.dm_server_registry
it show "Invalid object name..."
Any help?
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 24, 2012 at 2:45 am
Raghavendra Mudugal (2/24/2012)
SQL VersionMicrosoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
but when I query these two objects - Query sys.dm_service_services, Query sys.dm_server_registry
it show "Invalid object name..."
Any help?
you need SP1 as detailed in the QotD, your on 10.50.1600 which is the RTM, you need to upgrade to 10.50.2500
February 24, 2012 at 2:47 am
anthony.green (2/24/2012)
Raghavendra Mudugal (2/24/2012)
SQL VersionMicrosoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
but when I query these two objects - Query sys.dm_service_services, Query sys.dm_server_registry
it show "Invalid object name..."
Any help?
you need SP1 as detailed in the QotD, your on 10.50.1600 which is the RTM, you need to upgrade to 10.50.2500
and what that means "(Build 2600: Service Pack 3)" Is this not pertaining to SP?
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
February 24, 2012 at 2:53 am
Raghavendra Mudugal (2/24/2012)
anthony.green (2/24/2012)
Raghavendra Mudugal (2/24/2012)
SQL VersionMicrosoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (Intel X86) Apr 2 2010 15:53:02 Copyright (c) Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)
but when I query these two objects - Query sys.dm_service_services, Query sys.dm_server_registry
it show "Invalid object name..."
Any help?
you need SP1 as detailed in the QotD, your on 10.50.1600 which is the RTM, you need to upgrade to 10.50.2500
and what that means "(Build 2600: Service Pack 3)" Is this not pertaining to SP?
Nope, that is about your operating system.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 15 posts - 1 through 15 (of 31 total)
You must be logged in to reply to this topic. Login to reply