Visual Studio 2022 - suggestions stop working

padut

 I open VS 2022 , then open  a SQL editor , then open a connection.  The redgate form that loads the suggestions is visible at the lower right corner.

However, after some time (a couple of hours or after a hibernate) I no longer get the database suggestions.  The snippits however do still appear in the dropdown, I just miss the database suggestions (tables, columns,...) When I do a Refresh Suggestions   (Ctrl-Shft-D) nothing happens.

I do not load a database project, I just open a folder in visual studio.

Is there a way to solve this, or a workaround that I can force the refresh

Jon_Kirkwood

Hi @padut,

Thank you for contacting Redgate support & sorry to hear about the suggestions concern in VS 2022.

Can I confirm the version of SQL Prompt & VS 2022 you have installed, I'm not familiar with this issue being raised before and would like to try and replicate it and provide to our developers. 

padut

Hi Jon_Kirkwood,

I use SQL Prompt version 10.14.4.4865.

For Visual studio:

Microsoft Visual Studio Community 2022

Version 17.7.6

VisualStudio.17.Release/17.7.6+34221.43

Microsoft .NET Framework

Version 4.8.09037

Installed Version: Community

ADL Tools Service Provider   1.0

This package contains services used by Data Lake tools

ASA Service Provider   1.0

ASP.NET and Web Tools   17.7.274.37181

ASP.NET and Web Tools

Azure App Service Tools v3.0.0   17.7.274.37181

Azure App Service Tools v3.0.0

Azure Data Lake Tools for Visual Studio   2.6.5000.0

Microsoft Azure Data Lake Tools for Visual Studio

Azure Stream Analytics Tools for Visual Studio   2.6.5000.0

Microsoft Azure Stream Analytics Tools for Visual Studio

C# Tools   4.7.0-3.23517.17+9d4cc0304792762c34f41cbbec67a1fcd2dc764f

C# components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Common Azure Tools   1.10

Provides common services for use by Azure Mobile Services and Microsoft Azure Tools.

Cookiecutter   17.0.23189.3

Provides tools for finding, instantiating and customizing templates in cookiecutter format.

Microsoft Azure Hive Query Language Service   2.6.5000.0

Language service for Hive query

Microsoft Azure Stream Analytics Language Service   2.6.5000.0

Language service for Azure Stream Analytics

Microsoft JVM Debugger   1.0

Provides support for connecting the Visual Studio debugger to JDWP compatible Java Virtual Machines

NuGet Package Manager   6.7.0

NuGet Package Manager in Visual Studio. For more information about NuGet, visit https://docs.nuget.org/

Python - Profiling support   17.0.23189.3

Profiling support for Python projects.

Python with Pylance   17.0.23189.3

Provides IntelliSense, projects, templates, debugging, interactive windows, and other support for Python developers.

Redgate SQL Prompt   1.0.0.0

Write, format, and refactor SQL effortlessly

Redgate SQL Search   3.6.5.3820

Search functionality for SQL Server databases, from within Visual Studio

SQL Server Data Tools   17.7.12.0

Microsoft SQL Server Data Tools

Syntax Visualizer   1.0

An extension for visualizing Roslyn SyntaxTrees.

Test3ToolWindow   1.0

Empty VSIX Project.

ToolWindowHostedEditor   1.0

Hosting json editor into a tool window

TypeScript Tools   17.0.20829.2001

TypeScript Tools for Microsoft Visual Studio

Visual Basic Tools   4.7.0-3.23517.17+9d4cc0304792762c34f41cbbec67a1fcd2dc764f

Visual Basic components used in the IDE. Depending on your project type and settings, a different version of the compiler may be used.

Visual F# Tools   17.7.0-beta.23314.10+e612cf93b989503c89e3a5830090062b7ab5e143

Microsoft Visual F# Tools

Visual Studio IntelliCode   2.2

AI-assisted development for Visual Studio.

VsVim   2.10.0.6

VsVim is a Vim emulator for Visual Studio

hassan_imam

Hi @padut, 

Could you please try downloading the latest version of SQL Prompt to see if it resolves the issue? You can download the the latest version here:SQLPrompt_10.14.11.7894.exe

Best, 

Hassan 
Product Support Engineer