Is there a SQL Search API for VS2017.

NewToRedGate

I need to search if a certain "SearchString" is present or being used in any database(s).  It can be in a Stored Procedure, Table Name, Table Column Name, Stored Procedure references, Views, Synonyms, or any type of SQL Objects.

Thanks for any help you can give me.

Eddie D

Hi, thank you for your forum post.

There is no API for SQL Search.

However, SQL Search is available to use within VS2017.

You need to install SQL Server Data Tools (SSDT) which is not installed by default.  In order to use SQL Search within VS2017, you need to run the Visual Studio installer and select the Data Storage and Processing workload which includes the SSDT components.

Many Thank
Eddie