Top secrets of SQL Server Management Studio 2008

1. Top secrets of SQL Server Management Studio 2008 Louie Bao

2. Start up Command line parameters

3. Start up Ability to change the database for the connection. Especially useful when the default database is inaccessible. Connection properties Use colours to differentiate between development and production servers.

4. Go GoGo GO [count] GO is not a Transact-SQL statement, it is a command recognized by … and SQL Server Management Studio Code editor.

5. Keyboard shortcuts • Word Selection: Ctrl + w • Line Selection: Home, Shift + End • Vertical Range Selection: Alt (Hold) + Click and Drag

6. Keyboard shortcuts Advanced…

7. Keyboard shortcuts Tools -> Options -> Environment -> Keyboard

8. Find and replace (regex) Find what: create table:b*{\#:i} Replace with: if object_id('tempdb..\1') is not null\n\tdrop table \1\n\n\0

9. Find and replace (regex) Find what: {[:a')]}={[@(':a]} Replace with: \1 = \2

10. Template Template Explorer: Ctrl + Alt + T Specify Values for Template Parameters: Ctrl + Shift + M

11. Scripting Tools -> Options -> SQL Server Object Explorer -> Scripting

12. Tab Text Tools -> Options -> Text Editor -> Editor Tab and Status Bar