patternsqlMinor
Can't open a view's design in SSMS
Viewed 0 times
canssmsopendesignview
Problem
I get this error message (that you can see below), when I try to open a view's design. It's not happening with tables, only with views and only when I try to see the design, so I'm able to retrieve the data from it, for example with a select query. I got this error since we moved the database to another virtual server. I tried on different computers with different Windows (7 and 10) and SSMS (2008, 2010, 2012, 2014) versions.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)
------------------------------
BUTTONS:
OK
===================================
When I click on the details I am presented with the following information:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)
------------------------------
Program Location:
at Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.QueryStatus(Guid& pguidCmdGroup, UInt32 cCmds, OLECMD[] prgCmds, IntPtr pCmdText)
at Microsoft.VisualStudio.Platform.WindowManagement.DocumentObjectSite.QueryStatus(Guid& pguidCmdGroup, UInt32 cCmds, OLECMD[] prgCmds, IntPtr pCmdText)
at Microsoft.VisualStudio.Platform.WindowManagement.WindowFrame.QueryStatus(Guid& pguidCmdGroup, UInt32 cCmds, OLECMD[] prgCmds, IntPtr pCmdText)
at Microsoft.Internal.VisualStudio.Shell.Interop.IVsTrackSelectionExPrivate.Register()
at Microsoft.VisualStudio.Platform.WindowManagement.WindowFrame.ConnectSelectionContext()
at Microsoft.VisualStudio.Platform.WindowManagement.WindowFrame.Activate()
at Microsoft.VisualStudio.Platform.WindowManagement.WindowManagerService.viewManager_ActiveViewChanged(Object sender, ActiveViewChangedEventArgs e)
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
at Microsoft.VisualStudio.PlatformUI.ExtensionMethods.RaiseEvent[TEventArg
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)
------------------------------
BUTTONS:
OK
===================================
When I click on the details I am presented with the following information:
Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)
------------------------------
Program Location:
at Microsoft.VisualStudio.OLE.Interop.IOleCommandTarget.QueryStatus(Guid& pguidCmdGroup, UInt32 cCmds, OLECMD[] prgCmds, IntPtr pCmdText)
at Microsoft.VisualStudio.Platform.WindowManagement.DocumentObjectSite.QueryStatus(Guid& pguidCmdGroup, UInt32 cCmds, OLECMD[] prgCmds, IntPtr pCmdText)
at Microsoft.VisualStudio.Platform.WindowManagement.WindowFrame.QueryStatus(Guid& pguidCmdGroup, UInt32 cCmds, OLECMD[] prgCmds, IntPtr pCmdText)
at Microsoft.Internal.VisualStudio.Shell.Interop.IVsTrackSelectionExPrivate.Register()
at Microsoft.VisualStudio.Platform.WindowManagement.WindowFrame.ConnectSelectionContext()
at Microsoft.VisualStudio.Platform.WindowManagement.WindowFrame.Activate()
at Microsoft.VisualStudio.Platform.WindowManagement.WindowManagerService.viewManager_ActiveViewChanged(Object sender, ActiveViewChangedEventArgs e)
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
at Microsoft.VisualStudio.PlatformUI.ExtensionMethods.RaiseEvent[TEventArg
Solution
Because you are using a newer version of SQL Server than SSMS, I recommend you install a SSMS of same version or later than the SQL Server. There is no guarantee that an older version of SSMS will work on a newer SQL Server, but the opposite should work. SSMS should be backward compatible but no guarantee to be future compatible.
I know this answer is not what you want to hear but like stated in How do I ask a good question?:
Keep an open mind
The answer to your question may not always be the one you wanted, but
that doesn’t mean it is wrong. A conclusive answer isn’t always
possible. When in doubt, ask people to cite their sources, or to
explain how/where they learned something. Even if we don’t agree with
you, or tell you exactly what you wanted to hear, remember: we’re just
trying to help.
I know this answer is not what you want to hear but like stated in How do I ask a good question?:
Keep an open mind
The answer to your question may not always be the one you wanted, but
that doesn’t mean it is wrong. A conclusive answer isn’t always
possible. When in doubt, ask people to cite their sources, or to
explain how/where they learned something. Even if we don’t agree with
you, or tell you exactly what you wanted to hear, remember: we’re just
trying to help.
Context
StackExchange Database Administrators Q#183154, answer score: 8
Revisions (0)
No revisions yet.