In SQL Server 2012, I want to save the Query Options I set for a session. These are set in SSMS in Query > Query Options. Example: Results to Grid. There used to be a way to save these so you don't have to set them for every session, but I can't find it in 2012.
Sure thing. Go to "Tools" "Options" and then down to "Query Results" In the "General" tab you can decide if you want results to grid, text, or file. You can also go to the "Results to Grid" to set other options about the grid behavior. Also, you can go to "Query Execution", "SQL Server" and "Advanced" to turn on SET STATISTICS TIME or SET STATISTICS IO to on for all query windows. Neither of these will work for an existing query window. But close it and reopen it and you'll get what you need.