• Home
  • About
  • Contact
  • Links
Awesome
5.0
100

dave.harris.net

Sysadmin and part time Gadgeteer

Display the account that SQL Server is running under

Posted by dave on January 20, 2011 Leave a comment (0) Go to comments

This will display the current account that SQL Server is running under:

declare @sqlser varchar(20)
EXEC master..xp_regread @rootkey=’HKEY_LOCAL_MACHINE’, @key=’SYSTEM\CurrentControlSet\Services\MSSQLSERVER’,
@value_name=’objectname’, @value=@sqlser OUTPUT
PRINT ‘Account Starting SQL Server Service:’ +convert(varchar(30),@sqlser)

Sysadmin StuffAccount, SQL, SQL Server
← Importing PaperCut Print Logs into SQL Server
Excel error: “There was a problem sending a command to the program” →
RSS Feed
Follow me on twitter.
Facebook

Helpful? Buy me a...

or

Tag Cloud

AD Backup Batch Blackberry Camera CCTV CMD Command Database DB DIY DMA2100 Email Error Exchange Fix GP HP Hyper-V IIS MCE Microsoft Monitor MySQL Network Outlook PHP Powershell Printer PRTG Registry Remote Repair RIM S2000 Script Server Spam SQL VB VDI VM Windows X10 Zoneminder

Categories

  • DIY (22)
  • Funnies (3)
  • General (11)
  • Hedgehogs (7)
  • Home Automation (20)
  • Home Network (20)
  • Honda S2000 (10)
  • Misc Gadgets (7)
  • Sport (3)
  • Sysadmin Stuff (245)
  • Uncategorized (4)
  • Useful Software (31)
  • Web Development (6)
  • X10 (6)

Copyright © 2013 dave.harris.net

Δ Top