Solved

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

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL 2012 Syntax Error 5 24
Scheduling Jobs for Execution: 4 15
SQL Server Error Log - logging period 1 18
sql query Help 12 29
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 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

21 Experts available now in Live!

Get 1:1 Help Now