PROBLEM WITH COLLATION (NULL) CREATING A DATABASE SQL SERVER

1

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: ) 
    
asked by Mario Alberto López 28.12.2018 в 04:27
source

0 answers