Menu

SQL Server
T-SQL
DBA
Azure
Tutorials
Scripts
T-SQLpowered
Metamodel

Get Services and Service Accounts

9. 3. 2018

SELECT servicename, service_account
FROM [sys].[dm_server_services]
GO

72

Share:

Reset IDENTITY_INSERT setting for session in case it is ON for unknown table

List all Tables with IDENTITY column exists information

Most popular
- SQL Server
  
  Scalar Functions and Parallel Execution Plans
  27. 1. 2021
- BI
  
  Extracting Metadata from the Power BI Report File
  19. 12. 2020
- T-SQL
  
  Using Binary Hash as an Alternate Record Key
  17. 12. 2020
- Azure
  
  Run your first U-SQL script in Azure Data Lake (step-by-step tutorial)
  21. 10. 2019
Tags

administation C# constraints databases data types date & time DDL development DML errors Excel functions hierarchy indexes internals JSON MDS MERGE performance Power BI procedures replications security SELECT sequences sessions SSRS tables tools triggers TRY&CATCH U-SQL views XE XML

SQL Server
T-SQL
DBA
Azure
Tutorials
Scripts
T-SQLpowered
Metamodel

@ SQLpowered.com 2020