SQL server Service, Account, Trace Flag info

Question

SQL server Service, Account, Trace Flag info

SQLQuest29

SSCrazy Eights

Points: 8264
More actions
December 9, 2015 at 2:13 pm

#313748

Comments posted to this topic are about the item SQL server Service, Account, Trace Flag info
______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

Viewing 6 posts - 1 through 5 (of 5 total)

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

jrp12 Valued Member Points: 61 More actions · Answer 1

Code needs formatting but provided link https://gist.githubusercontent.com/TheRockStarDBA/298a99e8c82378ac7cd4/raw/a471574681bfc3749d1d56667f9f79538b1f16e4/GetSQLServerInfo.sql will give proper format....

Thanks for useful script...

dgmueller Grasshopper Points: 14 More actions · Answer 2

I ran this script and received the following errors:

Msg 170, Level 15, State 1, Line 71

Line 71: Incorrect syntax near 'max'.

Msg 156, Level 15, State 1, Line 87

Incorrect syntax near the keyword 'from'.

not sure where the sys.dm_server_services is

What database should this be running from and why is there an error for the varchar(max)?

Thanks

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

akljfhnlaflkj

SSC Guru

Points: 76202

December 17, 2015 at 11:03 am

#1846626

Thanks for the script.

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 4

dgmueller (12/17/2015)
I ran this script and received the following errors:
Msg 170, Level 15, State 1, Line 71
Line 71: Incorrect syntax near 'max'.
Msg 156, Level 15, State 1, Line 87
Incorrect syntax near the keyword 'from'.
not sure where the sys.dm_server_services is
What database should this be running from and why is there an error for the varchar(max)?
Thanks

THis should be run on master database. Seems like SSC has messed up formatting. Can you try running the code from my github gist.

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 5

Great avatar and encoding your name at the top of the script. Looks good.