Who altered the user roles

Hi Folks If you want to trace out who have alter the user roles in the SQL Server.here is the simplest way. Open SQL Server management studio and execute the below query select * from sys.traces Copy the output of sys.traces and replace it in the query path of below query SELECT TextData,StartTime,NTUserName,ApplicationName FROM fn_trace_gettable(‘C:Program […]

SQL Server DBA Team Knowledge Wave 1

Please register for Junior SQL Server DBA What to do & What not to do on Sep 13, 2014 2:00 PM IST at: https://attendee.gotowebinar.com/register/1233616123437806338 This webminar is usefull to the Junior DBA. Best Practices to follow SQL Server Optimal Settings. Database Optimal Settings Monitoring SQL Server Performace Activity Monitor Perfmon Change log how to do […]