I am creating a database with the following command:
CREATE DATABASE CARGADOR COLLATE SQL_Latin1_General_CP1_CI_AS
GO
When I execute the following command:
select [Collation] = DatabasePropertyEx('CARGADOR','Collation')
The result is:
Collation
NULL
The question is, why NULL
?
The result of the following command:
SELECT SERVERPROPERTY('collation') SQLServerCollation
,DATABASEPROPERTYEX('master', 'Collation') AS MasterDBCollation
SQLServerCollation MasterDBCollation
Modern_Spanish_CI_AS Modern_Spanish_CI_AS
Y SELECT @@VERSION
Microsoft SQL Server 2016 (SP1-GDR) (KB4458842) - 13.0.4224.16 (X64) Aug 18 2018 09:00:06 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows 10 Home Single Language 6.3 <X64> (Build 17134: )