SQL Server | Other
Additional SQL Server features and topics not covered by specific categories
Why is this happening?
Not possible to guess.
Connect to a wrong (test) server or a wrong (test) database?
Why isn't SQL Server returning all table records?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 61%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Ray
0
Reputation points
Hi MS Q & A
I'm running SQL 2019 on my production environment under a CMS.
When I load my users' records through the content management system I can see/retrieve all records; old and new. Even the ones created right now as expected. However, when I try to pull this same data via the SQL Query window, it does not pull anything past March 2022. In other words, I can't see the recent entries as I do via the CMS.
I ran multiple db checks to no avail.
Why is this happening?
Your prompt response is really appreciated!
SQL Server | Other
-
Viorel 127K Reputation points2023-08-03T19:27:54.9133333+00:00 Are you using a query that includes an ORDER BY dateColumn DESC?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous2023-08-04T03:08:11.6+00:00 Hi @Ray
If you only use SQL server, it is easier to troubleshoot the problem. Now it is not sure if the problem is with the CMS, which requires more information to troubleshoot.
-
Anonymous
2023-08-17T05:58:46.6366667+00:00 Hi,
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
Sign in to comment
2 answers
Sort by: Most helpful
-
Olaf Helper 47,621 Reputation points2023-08-04T06:05:32.9233333+00:00 -
Erland Sommarskog 134.7K Reputation points MVP Volunteer Moderator2023-08-03T21:17:32.7133333+00:00 I am sorry, but it is very difficult to assist with the information you have shared. We don't anything about your database. We don't know anything about your query.
There could be all sorts of reasons. As Viorel suggests, maybe you are getting all the rows, but you don't have an ORDER BY clause and jump to conclusion.
Or maybe the CMS is pulling your legs and have more than one table, and you are only querying a subset etc.
In fact, it may be better to find a forum devoted to the CMS, since people in such a forum is more likely to know the schema of the CMS than we are here.