Default size of results window SQL Server Management Studio or alternative
Any one who uses SQL Server 2008, or earlier variants, knows that when you run the commands in the window the results window pops up for the lower half of the screen. I do want to see my results but when only the first or top 10 results will do have the window is a waste. Is there a way I can change the default size of that window?
Also if this kind of functionality exists in VS 2008 or 2010 let me know and I'll abandon SQL Server Management Studio.
Solution
There's no way to change the default size of the results pane. You may want to try sending your results to a separate tab instead. You can adjust this setting for both Results to Grid and Results to Text.
Under the Tools -> Options menu:
- Using T-SQL EXCEPT with DELETE / Optimizing a query
- Default size of results window SQL Server Management Studio or alternative
- Check the time on datetime columns but ignore the date
- Why is WITH required when using NOLOCK on a remote table call?
- How can I move a table to another filegroup in MS SQL Server?
- Saving results with headers in SQL Server Management Studio
- How to display all records from the table ASP.NET MVC 3
- Pasting from SQL Server Management Studio to Excel concatenates columns
- SQL Server returns different record after insert on linked MS Access table
- Comma separated results in SQL
- Missing Integration Services Catalog in Management Studio
- Retrieve value from SQL
- Use Wildcard / Regex in filter settings of SSMS object explorer to find an object
- SqlServer: Login failed for user
- Query to check whether a column is nullable
- SQL SERVER 2008 GET LAST INSERTED VALUES
- SQL: How to fill empty cells with previous row value?
- USE statement before CREATE VIEW
- SQL server ERROR Ambiguous column name
- COALESCE Function in TSQL
- How to find SQL Server running port?
- generate x digit random number in sql server 2008 R2
- How to remove or alter the dbo prefix from SQL Server 2012 tables?
- Undo Table Partitioning
- Remove Overlap Time in SQL Server 2008
- Production SqlSiteMapProvider issue - all the items 'disappeared'?
- SQL Server SELECT LAST N Rows
- How to compare SQL Server CDC LSN values in C#?
- Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation
- CDC fails after attaching database to SQL Server 2008 R2 instance