question

mille-2116 avatar image
0 Votes"
mille-2116 asked mille-2116 commented

Databases that do not support a specific collation

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-generalsql-server-transact-sql
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

One of my database collations is compatibility_ 198_ 804_ 30001

What collation are you referring to here? I can't make connection between these numbers and collation names.

1 Vote 1 ·
BertZhoumsft-7490 avatar image
1 Vote"
BertZhoumsft-7490 answered mille-2116 commented

Hi,@mille-2116

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for sharing, it helped me and I'm ready to try uninstalling again.

0 Votes 0 ·
TomPhillips-1744 avatar image
1 Vote"
TomPhillips-1744 answered

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://docs.microsoft.com/en-us/sql/ssms/scripting/troubleshooting-intellisense?view=sql-server-ver16

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.