Rotating Header Image

Posts Tagged ‘Management Studio’

Select or Edit Top x Rows

Oct 27th, 2010
by Colin Stasiuk.
2 comments

So a little SQL Server Management Studio tip/trick for today (inspired by a user question… Thanks Brandon!!) When you right click on a table you’re given the options to Select Top 1000 rows or Edit Top 200 rows as shown below: If you choose to SELECT, SQL Server Management Studio will build your SELECT statement [...]

CMS Multiserver Query Result Default Settings

Jul 20th, 2009
by Colin Stasiuk.
No comments yet

Steve Jones commented on a blog post I did on Checking the SQL Server Agent Status on all SQL Servers and pointed out that my query didn’t return the Server Name with the resultset.  My first reaction/thought was “hmmm did my code not cut/paste correctly?” then it dawned on me that my default settings might [...]

Sound Notification When Query Finishes Executing

Mar 26th, 2009
by Colin Stasiuk.
4 comments

So on twitter this morning a question was asked about attaching a sound file to SQL Server Management Studio to play a sound when a query completes. So I decided to poke around the managment studio a bit and under Tools -> Options if you select Query Results there is a checkbox for playing the [...]

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.