Service Service Accounts

Question

Service Service Accounts

Viewing 15 posts - 16 through 30 (of 31 total)

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 1

Thank you Keon.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

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

Raghavendra Mudugal (2/24/2012)
Thank you Keon.

No problem Madagul. 😉

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

rfr.ferrari SSCertifiable Points: 6879 More actions · Answer 3

Kameswari Aravindh (2/23/2012)
The Option specified is wrong it is not Sys.dm_service_services but it is Sys.dm_server_services.....

+1

good question!!!

thanks!!

[font="Times New Roman"]rfr.ferrari[/font]
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 4

Sorry for this off-topic question.

I just installed SP1 on the vmbox running SQL 2008 R2 and can see these objects accessible.

Just wanted to know, now I see that SP2 is available. So can I upgrade the existing to SP2 or is recommended that I keep SP1 and clone the existing vm and install SP2 on that? (so I will be having SP1 and SP2 both running on different OSs)

Please advice.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Ant-Green SSC Guru Points: 113507 More actions · Answer 5

Raghavendra Mudugal (2/24/2012)
Sorry for this off-topic question.
I just installed SP1 on the vmbox running SQL 2008 R2 and can see these objects accessible.
Just wanted to know, now I see that SP2 is available. So can I upgrade the existing to SP2 or is recommended that I keep SP1 and clone the existing vm and install SP2 on that? (so I will be having SP1 and SP2 both running on different OSs)
Please advice.

There is no SP2 for 2008 R2 yet.

SP2 is only released for the original 2008

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 6

thank you Antony. (yes, R2 is different, 2008 and 2008 R2 needs to be treated as two different things)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 7

Erm....the answer options were incorrect. only 1 option was correct.

select * from sys.dm_service_services --<-- As in the question, this doesnt exist

select * from sys.dm_server_services --<-- As in the explanation, this does.

There is a difference between Service and Server.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Dana Medley SSCertifiable Points: 6764 More actions · Answer 8

'Tis a sad fate that I got the question wrong on a Friday. 🙁 But, I did learn something today and...it's Friday :w00t: so I'll take knowledge over my missed point any day.

Almost forgot to mention, great question Steve!

Everything is awesome!

Lon-860191 SSCrazy Points: 2449 More actions · Answer 9

Lon-860191

SSCrazy

Points: 2449

February 24, 2012 at 8:05 am

#1451419

Good question, other than the typo.

Thanks!

Cliff Jones SSChampion Points: 10547 More actions · Answer 10

Henrico Bekker (2/24/2012)
Erm....the answer options were incorrect. only 1 option was correct.
select * from sys.dm_service_services --<-- As in the question, this doesnt exist
select * from sys.dm_server_services --<-- As in the explanation, this does.
There is a difference between Service and Server.

Thanks, that explains why it wasn't working on my SQL 2008 R2 SP1 instancce.

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 11

no worries - other than the type... tks for question & TGIF!!!

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

Kameswari Aravindh (2/23/2012)
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:

+1

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 13

Got it wrong, but learned something today. Thanks for the question.

http://brittcluff.blogspot.com/

TomThomson SSC Guru Points: 104773 More actions · Answer 14

Oh dear, one of those times where one has to guess which is the typo: was "select 2" a typo for "select 1" or was "sys.dm_service_services" a typo for "sys.dm_server_services".

I thought 2 for 1 was an unlikely typo. But others have the other choice, and ought to get their points awarded.

Tom

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 15

SQL_Hunt

SSC-Dedicated

Points: 33518

March 5, 2012 at 10:39 pm

#1455105

Not a bad question .. !

Thanks.