SSMS Becomes "Not Responding" and Shuts Automatically When Clicking "Design" on SQL Database's View

-
I faced a problem from SSMS which doesn't show any error when I wanted to see the "Design" of a SQL Database's View.

There is a similar post here.
I would say similar because my problem was a bit different than that post as my SSMS didn't even display any error, it just became "Not Responding" and closed itself automatically.

There was an AccessViolationException when I looked into the event of that SQL application, such as the following (also similar stacktrace):


The solution is... the same with the solution in the post above :)
My version of SSMS (2016) is older than the SQL Server itself (2017).

Another good reference which I referred for getting the version information is this: https://buildnumbers.wordpress.com/sqlserver/

Comments

Post a Comment

Popular posts from this blog

Windows could not start the Sitecore Xconnect Search Indexer - {xConnectInstance}-IndexWorker service on Local Computer. Error 1064: An exception occurred in the service when handling the control request.

-
Image
I was doing upgrade from Sitecore 9 Initial Release to Sitecore 9 Update 1. I felt somehow confident that I have followed all the steps of upgrade guide correctly, but when I reached to the step in resuming service (page 47 in the document: “Start the Sitecore XConnect Search Indexer Windows service” ), I faced the following error: “Windows could not start the Sitecore Xconnect Search Indexer - {xConnect Instance}-IndexWorker service on Local Computer. Error 1064: An exception occurred in the service when handling the control request.” Based on MSDN , this error means: “ While handling a control request, the service attempted to access an illegal address. ” I then tried to run this application manually from the folder containing it ( C:\inetpub\wwwroot\<xConnectInstance>\App_data\jobs\continuous\IndexWorker ). It is clear that this error refers to the connection string which I obtained by copying and pasting directly (my mistake during installation...
Read more

EXM Throws NonCriticalException "Failed to download string content" with Nested Exception of "403 Forbidden" in Azure Web App

-
Image
 Upon previewing email content in Azure Web App, one could get the following error: 9668 03:27:56 ERROR Exception: Sitecore.EmailCampaign.Model.Web.Exceptions.NonCriticalException Message: Failed to download string content, URL: https://testazure-cm.azurewebsites.net/?sc_itemid=%7B229384AB-6279-42BC-925F-1D28C0227C03%7D&sc_lang=en&sc_device=%7BFE5D7FDF-89C0-4D99-9AA3-B5FBD009C9F3%7D&ec_database=master&ec_id=96F0189C036942DDA62BCE8D68C6D1C7&ec_message_id=583137BAD51D4491AD8D07451BCC9000, Use IIS Credentials: True, UserAgent: ECM Dispatch Source: Sitecore.EmailCampaign    at Sitecore.Modules.EmailCampaign.Core.WebContent.DownloadString(String url, Boolean useIisCredentials, String userAgent)    at Sitecore.Modules.EmailCampaign.Messages.WebPageMail.GetMessageBody(Boolean preview)    at Sitecore.EmailCampaign.Cm.MessageInfo.FillContentEditorInfo() Nested Exception Exception: System.Net.WebException Message: The remote server returned a...
Read more

Modify the text of the Action menu in Sitecore Horizon

-
Image
Sometimes someone may want to modify the text in the Horizon's menu action(s), for example there is a case like this. The rename action in Sitecore Horizon changes the "display name" instead of the item name, e.g: Just in case anyone wants to modify that, one can go to the file in the directory such as: "C:\inetpub\wwwroot\HORIZON_SITE\sitecore\Sitecore.Horizon.Client\Client\dist\assets\i18n\ en.json ". For the case of "rename" above, one can go to the section "CHANGE_DISPLAY_NAME" After that, please recycle the application pool. The modification above would result in something like:
Read more