ssms –log

If you haven’t come across the –log switch before, here are a few basic screen shots of it in action on SQL Server 2014.


I didn’t supply a log file to use, so the 2 files ActivityLog.xml and ActivityLog.xsl were created by default under C:\Users\yourdba\AppData\Roaming\Microsoft\AppEnv\10.0


Opening the ActivityLog.xml file using Internet Explorer gives the following info:
(click to see a larger image)


So, if you’re having issues with ssms and your version supports the log switch, then this may be of some use to you.

Leave a Reply