dbo schema question

SQLDev 96 Reputation points
2022-05-19T03:11:49.837+00:00

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
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,477 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 40,156 Reputation points
    2022-05-19T05:37:34.947+00:00

    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.

    0 comments No comments

  2. YufeiShao-msft 7,046 Reputation points
    2022-05-19T06:04:53.073+00:00

    Hi @SQLDev ,

    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.

    0 comments No comments