SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

SQL server Service, Account, Trace Flag info

By Kin Shah,

This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server  related services along with startup trace flags.

This script uses sys.dm_server_services, sys.dm_server_memory_dumps and sys.dm_server_registry that were introduced in SQL Server 2008R2 SP1 and up - Build 10.50.2500.0.

[You can find me at - http://dba.stackexchange.com/users/8783/kin?tab=profile]

Total article views: 992 | Views in the last 30 days: 1
 
Related Articles
BLOG

SQL Server Service Information

DMV: sys.dm_server_services Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of...

BLOG

Your Devs' Questions Answered With sys.dm_server_services

It starts with "I'm a developer... "... with no RDP access, how can I tell if the SQL Server Agen...

BLOG

SQL Server 2017 sys.dm_os_enumerate_fixed_drives

In SQL Server 2017,  you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk ...

FORUM

SQl server Stop Service

SQl server Stop Service

FORUM

Restart SQL Server services

Restart SQL Server services

Tags
administration    
sql agent    
 
Contribute