3 ms·

I use MS SQL Server a lot at work. I interact with instances via SSMS usually. I'd love a tool that would log to file every query that I execute. Including a cu

I use MS SQL Server a lot at work. I interact with instances via SSMS usually. I'd love a tool that would log to file every query that I execute. Including a customisable comment line with info including when it was run and the server/db it was run against. I'd move to a command line tool, e.g. a sqlcmd variant or shell voodoo, if it could do that.

andix 4y ago
Try out JetBrains Datagrip (or any IDE that includes it), it’s much more flexible than SSMS. Not sure if this exact feature exists, but they have a plugin interface, maybe you can write one on your own. They have a log already: https://intellij-support.jetbrains.com/hc/en-us/community/posts/203930310-How-can-I-see-all-query-made-by-DataGrip- https://intellij-support.jetbrains.com/hc/en-us/community/po...