Thursday, January 13, 2011

Shortcut to enable Fullscreen in SSMS

Today I was experimenting with the query results in Sql server management studio and saw this shortcut in he View menu of the SSMS.



So in order to show full screen I tried the shortcut -- Shift + Alt + Enter. The same shortcut works to come out of the full screen mode as well. What the full screen does is closes all the other windows and like object explorer, registered servers etc that you have open and maximises the query and results windows.

Likewise if you want to go to the properties just press F4.
To get the Solution Explorer window the shortcut is Ctrl + Alt + L
To get the Toolbox window -- the shortcut is Ctrl + Alt + X

Hope these shortcuts are useful for you.

No comments:

INSERT EXEC failed because the stored procedure altered the schema of the target table.

This morning I was trying to call a stored procedure and insert the results in a temp table using the following code  -- create table #...