Category Archives: SQL Server

Problem You can simply use SQL Server Configuration Manager to realize what is the SQL Server Service Account, but what if for any reason you are not able to use it. how can you find the service account using T-SQL? Solution Simple and easy:

Problem You may run the sp_WhoIsActive to check the currently active sessions in your SQL Server and find an active session from one of your jobs. if you look at the program_name column, you’ll see something like this: So, how do you find the corresponding job? Solution You can find all of the SQL ServerContinue reading “How to find a SQL Server job with a binary job id”