SQL Server - EM -Tips and Tricks
- When you click a Table, View or Proc name in Enterprise Manager, right click, select “Copy“ and paste in any editor, it pastes the entire script of the table. A nice feature in EM, most users are not aware of
- You can create a copy of a database by using the “Copy Database“ wizard in EM. This wizard can be found under Tools -> Wizards -> Management -> Copy database Wizard. (This is particularly interesting since Dominic Morris has blogged about want of such a utility here )
- You can insert a null value into a nullable field by pressing “Ctrl+0” while editing a table in EM.
- You can use the Server -> DBName -> Diagrams in EM to create relationships by viewing the tables as a diagram and then using drag and drop to link the tables. It provides a visual tool for creating a database. Very easy to use and very high fuctionality.
Will be putting up a blog on how to use the Diagrams effectively soon.