Solved

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

Posted on 2011-03-24
1
222 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
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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
triggered use of sp_send_dbmail failure 2 23
Dimension table indexes 8 14
Get Duration of last Status Update 4 32
sql query questions 2 25
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now