Unable to modify the stored procedure spLDW_UpdateCustomComputerEndpointData

Products

• Information Centric Analytics

Issue/Introduction

The following error is returned when attempting to modify the stored procedure spLDW_UpdateCustomComputerEndpointData, or any other stored procedure, using Microsoft SQL Server Management Studio (SSMS):

Invalid version: 15. (Microsoft.SqlServer.Smo)

--------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=14.0.17289.0+((SSMS_Rel_17_4).181117-0805)&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.ScriptingOptions.ConvertToSqlServerVersion(Int32 majorVersion, Int32 minorVersion)
   at Microsoft.SqlServer.Management.Smo.ScriptingOptions.ConvertToSqlServerVersion(ServerVersion serverVersion)
   at Microsoft.SqlServer.Management.UserSettings.ScriptingOptions.GetSmoScriptingOptions(SqlSmoObject smoObj)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.ScriptExistingTextObjectToWindow(IManagedConnection mc)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.InvokeTextObject(IManagedConnection connection)
   at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.Invoke()

----------------------------

----------------------------

Environment

Release : 6.x

Component : Microsoft SQL Server

Cause

This error is caused by an incompatibility between SQL Server 2019 and SSMS versions prior to version 18.

Resolution

Upgrade SSMS to version 18 or later.