HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Can't open a view's design in SSMS

Submitted by: @import:stackexchange-dba··
0
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

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.

Context

StackExchange Database Administrators Q#183154, answer score: 8

Revisions (0)

No revisions yet.