Month: <span>January 2020</span>

Find who dropped Database at what time in SQL Server

by Sanjay Humania

Scenario As a DBA often we face a scenario that someone has dropped the database and we need to find…

Provide a SQL Login ‘profiler access’ by ‘ALTER TRACE permission’

by Sanjay Humania

Scenario One SQL login holder asked DBA team “Please provide me profiler access urgently“. Mentioned user using a SQL login…