June 23, 2008 at 1:00 pm
Can anyone tell me if it is possible to change the defaults for query options(Query/Query options)? I would always like to see my resultin in a seperate tab, have column headings and have tab delimited when requesting results to grid.
June 23, 2008 at 3:41 pm
For an extensive course in how to use SQL Server Management Studio (SSMS) and I mean extensive
http://msdn.microsoft.com/en-us/library/ms166996.aspx
For a short quickie
Open SSMS
Connect to a server
1. In top tool bar select "Query"
2. Move down to next to last item in the displayed menu "Results to"
3. Select which one of the three options you want.
Repeat step 1.
4 Move down to the last item in the displayed menu "Query options"
5. In the displayed window select from the left hand pane "Results"
6. In the right hand pane select / set those items you desire
7. Select OK and you should be good to go
June 24, 2008 at 7:09 am
Guess I forgot to mention that I am using SQL Server Management Studio Express. There is no Query option in the tool bar. I can set it for every query I run, but that gets old fast.
June 24, 2008 at 12:07 pm
Refer to this
http://msdn.microsoft.com/en-us/library/ms166556.aspx
to set startup options - Be sure to review each item in that Environment window - think some of it will do what you want. Note you must restart SSMS to have them take effect.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply