sql-server-2016azure-data-studioschema-compare

Apply SQL Server schema after 'schema compare' show error


Versions in use:

Problem: there is something wrong with my Azure Data Studio apply schema to SQL Server 2016.

It say I'm not the login manager but there is no login manager role in SQL Server.

And it has worked before updating Azure Data Studio to v1.36.X

https://i.sstatic.net/zqLa1.jpg


Solution

  • Finally, I found the problem Misused sqllinlinetablevaluedfunction and sqlmultistatementtablevaluedfunction In my project There are many function use sqllinlinetablevaluedfunction instead of sqlmultistatementtablevaluedfunction but It's should be used sqlmultistatementtablevaluedfunction so I change to Correct Type then It's worked. The error never show