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
What are the values in the Date field?
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
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.
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
What about the particular DBs compatibility level settings?
Please, sign in to be able to submit a new answer.