Kentico k11 and k12 record sequence not matched

pankaj saxena asked on April 3, 2023 06:34

Hi Members,

Is anyone have any idea related the record of the database sequence is not match in Kentico.

Like: I have a k11 Kentico database and k12 kentico database both contain the same table with same of the record, if we run a query on the database based on the condition like:- order by date desc so the return result set sequence not same.

Like: in k11 the sequence is Storage Expansion,St. Mary's, Belvue and Wamego but in k12 the sequece is St. Mary's, Belvue and Wamego,Storage Expansion

Recent Answers

Juraj Ondrus answered on April 3, 2023 06:49

What are the values in the Date field?

0 votesVote for this answer Mark as a Correct answer

pankaj saxena answered on April 3, 2023 07:24

Hi Juraj,

I get the record based on the filter order by Date desc value of the data field in both k11 and k12 is 1/1/2012 12:00:00 AM

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on April 3, 2023 08:18

So, I would check with SQL server support how this command works in case the values in the desired field are the same. There should not be nothing in Kentico DB - it is a standard MS SQL database. Or, check if on Stackoverflow had the same issue.

0 votesVote for this answer Mark as a Correct answer

pankaj saxena answered on April 3, 2023 13:34

Hi Juraj, in both k11 and k12 same database is used. Microsoft SQL Azure (RTM) - 12.0.2000.8 Mar 8 2023 17:58:50 Copyright (C) 2022 Microsoft Corporation

0 votesVote for this answer Mark as a Correct answer

Juraj Ondrus answered on April 3, 2023 14:16

What about the particular DBs compatibility level settings?

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.