Normally it should be the Job owner(owner_sid) however if the account is shared within the team then it will be difficult to capture who exactly modified the job status(enable/disable). SELECT sysjobs.name as JobName, sysjobs.enabled, sys.sysusers.name AS OwnerName, sys.sysusers.sid FROM ...
One of my Application server has been restarted yesterday, we would like to know how to find the login information and the IP details of the server. Please help me how to get the information who did restarted SQL services! Thanks in advance, DBA DBA All replies (5) Monday, February 13,...
How to Drop a user from a database who owns a dbo schema and is the dbo How to execute jobs in parallel from SQL Server Agent How to export an entire schema (all objects inside it) in SQL Server 2016 How to find multiple instances of SQL Server? How to find old deadlock informatio...