SQL Server with Mr. Denny:

SQL Server Management Studio

1

July 14, 2011  6:33 PM

Updated SSMS Shortcut Key file



Posted by: Denny Cherry
Shortcut Keys, SQL Server, SQL Server 2012, SQL Server Management Studio

I've updated the SQL Server "Denali" settings file to include the CTRL+E and CTRL+X hot keys.  You can find the new file in the same location as the old one so you only need to download it once. Denny

July 14, 2011  2:56 AM

Resetting SSMS shortcut keys in SQL Server “Denali” CTP 3



Posted by: Denny Cherry
Hot Keys, Shortcut Keys, SQL Server, SQL Server 2012, SQL Server Management Studio

If you did what I did when you installed CTP 3 of SQL Server "Denali" (which happened when I uninstalled CTP 1 then installed CTP 3) you'll be in for a rude surprise, a lot of your shortcut keys that you've been using for years don't work any more.  This is to say the least VERY annoying, and...


April 14, 2011  2:00 PM

So you’ve changed the text display settings, and SSMS still won’t show more than 256 characters.



Posted by: Denny Cherry
SQL Server, SQL Server 11, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server Management Studio

By default SQL Server Management Studio will only show you 256 characters per column.  The fix for this is pretty easy.  You click on Tools > Options to being up the options menu.  From there navigate to Query Results > SQL Server > Results To Text.  Change the "Maximum number of...


July 29, 2010  11:00 AM

Running a query against multiple servers at one



Posted by: Denny Cherry
SQL Server 2008, SQL Server 2008 R2, SQL Server Management Studio

So you've got a bunch of machines that you want to run a quick query against.  SQL Server 2008's Management Studio gives you a quick and easy.  Open up the Registered Servers in Management Studio and select a group of servers.  Then right click on the group and click on the "New Query"...


March 27, 2009  3:04 AM

Making SSMS Beep



Posted by: Denny Cherry
Colin Stasiuk, EarthLink, Ping, SQL Server Management Studio

Today I read a post from my good friend Colin Stasiuk (aka @BenchmarkIT) where he talked about


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: