Overview Query and Text Editors (SQL Server Management Studio) Database Engine Query Editor (SQL Server Management Studio) XML Editor (SQL Server Management Studio) Configure Editors (SQL Server Management Studio) Associate File Extensions to a Code Editor Change Font Color, Size, and Style Use the Properties Window in Management Studio Open an Editor (SQL Server Management Studio) Manage the Editor and View Mode Manage Code Formatting Navigate Code and Text Color Coding in Query Editors Code Outlining Drag and Drop Text Search and Replace Search an Active Document Incrementally Search Documents Interactively Search Documents Using Results Lists Search Text with Wildcards Search Text with Regular Expressions Find and Replace Find in Files Find Results Windows Replace in Files Manage Bookmarks Bookmarks F1 Help Print Code and Results Edit SQLCMD Scripts with Query Editor IntelliSense (SQL Server Management Studio) Configure IntelliSense (SQL Server Management Studio) Parameter Info (IntelliSense) Quick Info (IntelliSense) Complete Word (IntelliSense) Automatic Matching of Syntax Pairs Troubleshooting IntelliSense (SSMS) Transact-SQL Syntax Supported by IntelliSense Transact-SQL Code Snippets Insert Transact-SQL Snippets Insert Surround-with Transact-SQL snippets Complete Transact-SQL Snippets Add Transact-SQL Snippets Transact-SQL Debugger Configure firewall rules before running the TSQL Debugger Run the Transact-SQL Debugger Step Through Transact-SQL Code Transact-SQL Breakpoints Toggle a Breakpoint Enable, Disable, and Delete Breakpoints Specify a Breakpoint Condition Specify a Hit Count Specify a Breakpoint Filter Specify a Breakpoint Action Edit a Breakpoint Location Transact-SQL Debugger - Information Transact-SQL Debugger - Error List Window Transact-SQL Debugger - Breakpoints Window Transact-SQL Debugger - Call Stack Window Transact-SQL Debugger - Locals Window Transact-SQL Debugger - Threads Window Transact-SQL Debugger - Command Window Transact-SQL Debugger - Output Window Transact-SQL Debugger - Watch Window Transact-SQL Debugger - QuickWatch Dialog Box Status Bar (Database Engine Query Editor) View Spatial Data in Object Explorer Spatial Results Window sqlcmd Start the Utility Use the Utility Connect to the Database Engine Run Transact-SQL Script Files Use with Scripting Variables SQL Server PowerShell Import the SQLPS Module Load the SMO Assemblies in Windows PowerShell Run Windows PowerShell from SQL Server Management Studio Run Windows PowerShell Steps in SQL Server Agent SQL Server PowerShell Provider Navigate SQL Server PowerShell Paths Work With SQL Server PowerShell Paths Convert URNs to SQL Server Provider Paths Use the Database Engine cmdlets SQL Server Identifiers in PowerShell Specify Instances in the SQL Server PowerShell Provider Encode and Decode SQL Server Identifiers Escape SQL Server Identifiers Manage Authentication in Database Engine PowerShell Manage Tab Completion (SQL Server PowerShell) Get Help SQL Server PowerShell SQL Server PowerShell License Terms Generate Scripts (SQL Server Management Studio) Generate and Publish Scripts Wizard Objects Supported by the Generate Scripts Wizard