SSMS usage tips
Few tips I would share with the community about usage of SSMS tool within your environment, you can get acquaintance with SSMS quickly by using these features:
- Use Open empty environment option to speed up the loading of SSMS, this is how you do: at SSMS startup, navigate to Tools | Options | Environment | General and change "At startup" setting to "Open new query window" in SQL Server Management Studio.
- SQL Server Management Studio allows you to use the SQL Server 2000 keyboard scheme. See Tools | Options | Environment | Keyboard for this. By default, it uses the Standard scheme, with keyboard shortcuts based on Microsoft Visual Studio .NET.
- Query Options toolbar item (or Query | Query Options menu item) allows quick access to various options for current connection. You can use this to configure things like ROWCOUNT, TEXTSIZE, and various other SET settings.
- SQL Server Management Studio is fully integrated with Microsoft Visual SourceSafe source code control system. See Tools | Options | Source Control and File | Source Control menu items for this.
- To open up Template Explorer for TSQL query writing use Ctrl + Alt + T.
- See Taskpad type of information as it was in SQL2000 Enterprise manager: General tab in Database section is now in database properties under the same heading.
- Script multiple Stored Procedures including permissions:
Right-click the database->Tasks->Generate Scripts, pick your database. Set Include object Level Permissions to True. Note: If you set the Include if NOT EXISTS option to true, the script will not create the stored procedure if it already exists on target database.
Click Next, and select Stored Procedures only. Next select which procs you want to script, review you final options and click Finish.