1

I am having this issue where Schema Compare in Visual Studio 2019 has detected that we don't have an SQL Stored Procedure and want to delete it from the live database, but if you can see the attached screenshot, we do have the stored procedure in Visual Studio SQL project.

If I compare the other way around, it tries to add the procedure to the project with a P_S_GetCaseAccountRolesAndCustomers**_1**.sql filename

False detection

Aasim Shakil Pathan
  • 41
  • 1
  • 10

1 Answers1

0

This happens when your file (local) divert from the database (SSMS). For example, your stored procedure is now ALTER instead of CREATE.

JakeWu123
  • 1