Copyright © 2008-2019 Paula DiTallo

Tag Cloud

January 2019 Entries

SQL Server: How can I tell which service account SQL Server is running under?

This query will provide the basicsSELECT DSS.servicename, DSS.startup_type_desc, DSS.status_desc, DSS.last_startup_time, DSS.service_account, DSS.is_clustered, DSS.cluster_nodename, DSS.filename, DSS.startup_type, DSS.status, DSS.process_idFROM sys.dm_server_services AS DSS; ......

How can I tell which node is the primary, or 'active' node in a SQL Server Cluster

Issue this command from the master db Select ServerProperty('ComputerNam... ......