Solved

changeing a default setting for the query window in microsoft SQL Server Management Studio 2008

Posted on 2011-03-24
1
260 Views
Last Modified: 2012-05-11
is there a way to change a setting in microsoft SQL Server Management Studio 2008 so that it does not default to have every field checked when you bring up the edit top xxx rows screen.

it also populates all fields if you use an astrisk in the column.

i would rather have it like the previous version of sql where the * meant use all...  
i often use grouping when researching data and the * then becomes a count field which is very useful
0
Comment
Question by:CASorter
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 4

Accepted Solution

by:
RGBDart earned 500 total points
ID: 35207437
No, there is no such way.

The only thing you can customize for "Edit top xxx rows" feture is the "xxx" value (Tools->Options->SQL Server Object Explorer -> Commands).
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question