I'm using Sql Server 2005 Management Studio on my client machine against Sql Server 2000 databases. For some reason, when I right-click to create a new diagram, the option isnt available.

Your database may get damaged due to several reasons. A backup will help you to restore the database lost in case of disasters and problems, like hardware failure, virus attack, or others. How To ...

Joey on SQL Server How To Automate Tasks in Azure SQL Database Knowing how to automate tasks in the cloud will make you a more productive DBA.