1: SELECT DSS.servicename,
2: DSS.startup_type_desc,
3: DSS.status_desc,
4: DSS.last_startup_time,
5: DSS.service_account,
6: DSS.is_clustered,
7: DSS.cluster_nodename,
8: DSS.filename,
9: DSS.startup_type,
10: DSS.status,
11: DSS.process_id
12: FROM sys.dm_server_services AS DSS;
Monday, 31 August 2020
Getting SQL Server Instance Services Information
Below query can be run to get SQL Server instance services information:
Subscribe to:
Post Comments (Atom)
How to Handle SSIS Database movement from one environment to another
Below are the steps to follow the movement of SSISDB from one environment to another: -- opening the existing Database master key in S...
-
We can execute SSIS packages deployed in SSIS Catalog using stored procedure based approach as given below: DECLARE @execution_id I...
-
When we want to see how many files are using a specific keyword, we can use below powershell script to do this. This will be helpful if we w...
-
Below are the steps to follow the movement of SSISDB from one environment to another: -- opening the existing Database master key in S...
No comments:
Post a Comment