How to generate ER-Diagram in Microsoft SQL Server?

To generate the ER-Diagram or the pictorial representation of the database in Microsoft SQL Server
2005/2008-
1. Set all the references and keys in the database tables
2. Connect to the server
3. Select the database of which you want the ER-diagram
4. Expand the database diagrams
5. A message will come like the below diagram

 

6. Select Yes in the above message

7. Right Click on the database diagrams and select new database diagram

8. Select the table you want in the pop up window and click ADD.

9. Then you will get the diagram

10. If you want to copy the diagram, right click on the diagram and select 'copy to clipboard' and paste it in new paints file.

11. Save it as you like.