Error:
When click 'New Database Diagram', a error popped up and said 'attempted to read or write protected memory. This is often a indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)"
Related Link:
https://social.msdn.microsoft.com/Forums/en-US/fa9df00f-49ba-4345-b036-423ae30a5d47/ problem-to-create-new-database-diagram-in-microsoft-sql-server-management-studio-for-sql-server?forum= SQLExpress
Http://stackoverflow.com/questions/16856548/database-diagrams-inaccessible-after-change-of-database-name
Solution:
You'll need a second computer with either SQL Server and/or Visual Studio installed. Then use the second computer to copy the. dll files specified in the steps below, and replace the corresponding files on t He computer where the database diagrams is not working.
Step 1:replaced The following File:c:\program Files (x86) \common Files\Microsoft Shared\visual Database Tools\dsref80.dl L (Note:this one need according to link 1 and link 2 ' s problem is different)
Step 2:replaced All files in the following Folder:c:\program files (x86) \common Files\Microsoft Shared\msdesigners8\
Problem to create "New Database Diagram" in Microsoft SQL Server Management Studio for SQL Server 2012