Databases that do not support a specific collation

mille 126 Reputation points
2022-05-25T14:49:19.333+00:00

Hi,Teams!
I have a problem. One of my database collations is compatibility_ 198_ 804_ 30001.
In SQL Server 2008 Management Studio, the smart sensing function is normal, but after upgrading SQL Server 2012, the smart sensing function fails. Confirm that SQL Server 2012 Management Studio operates other collation databases and the IntelliSense function is normal. The same problem was also found with Microsoft SQL Server Management Studio 18.
How to solve it?

Thank you in advance.
Mile

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,486 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,536 questions
{count} votes

Accepted answer
  1. Bert Zhou-msft 3,421 Reputation points
    2022-05-26T06:01:07.027+00:00

    Hi,@mille

    Welcome to Microsoft T-SQL Q&A Forum!

    I saw a post before that said that in order to restore intellisense you have to take the necessary database offline,Restart the server instance and finally refresh the Intellisense cache .
    Maybe you can try it, or use the plugin: SQL Complete Express by devArt. Share a link to you, hope it helps.

    Bert Zhou

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Tom Phillips 17,716 Reputation points
    2022-05-25T16:02:56.337+00:00

    I am unclear if you have a problem. You talk about collation and Intellisense.

    There are many, many reasons why Intellisense does not work in SSMS. I do not know of any relating to database collation.

    https://learn.microsoft.com/en-us/sql/ssms/scripting/troubleshooting-intellisense?view=sql-server-ver16

    1 person found this answer helpful.
    0 comments No comments