SQLServer mangement studio connection error

Question

When I click to open a new query SSMS return an error like image bellow. If I click 'ok I am able to run any query. This error occur even when I right click on SQLQuery window and chose a new connection. All the SSMS configurations are defaulted

Answer 1

That's sort of interesting - the error message suggests that there is a syntax error in the commands that SSMS emits when you start up a new query window.

First of all, which version of SSMS do you have? The most recent version is 19.0.2. You may want to try that to see if the issue has been resolved.

If it does, start Profiler to "spy" on SSMS to see what commands it submits when you open a new query window. Be sure to include the Starting events, since they will not complete if there is a syntax error.

Answer 2

Hi @afonso vianna

Try generate scripts using the in-built Generate Scripts task in SSMS and set the Script for Server Version on the Advanced Scripting Options dialog to the correct version of SQL Server you wish to target with the script.

In SQL Server Management Studio, right click the DB -> Tasks -> Generate Scripts option.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.