question

Maheshchintamani-5854 avatar image
0 Votes"
Maheshchintamani-5854 asked Yufeishao-msft commented

dbo schema question

We have sql server 2019 enterprise edition with latest service pack. SQL collation is SQL_Latin1_General_CP850_BIN2. While creating a table under DBO schema, I am getting the error as - The specified schema name "DBO" either does not exist or you do not have permission to use it. I have dbo schema under the database where I am trying to create the table. Not sure why I can't create table under DBO schema. It allows me to create the table under dbo schema though. Any ideas? Thx

sql-server-general
· 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.

Could you please validate all the answers so far and provide any update?
Please remember to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.

Thank you for understanding!

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

SQL_Latin1_General_CP850_BIN2. ... schema name "DBO" either does not exist

You have a binary collation and a binary collation is more then just case-sensitive, each byte of data must match.
And the correct case for that standart schema is "dbo" (lower), not "DBO" (upper case).
You must use the correct case for very each letter.

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.

Yufeishao-msft avatar image
0 Votes"
Yufeishao-msft answered

Hi @Maheshchintamani-5854,

According to this article:Collation and Unicode support

_BIN2 is Binary-code point, they are case-sensitive, A binary collation in SQL Server defines the locale and the ANSI code page that's used. This enforces a binary sort order.



-------------
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.




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.