My table wont show anymore data past the first 1000

Question

My table wont show anymore data past the first 1000

Austin Hunter 0

Hello all,

I'm using ssms ver9 w/ windows auth, and database server type. I'm having trouble see the most recent data. I'm using Rockwell factory talk to write data but, noticing its only showing the fist 1000 rows. According to ssms I haven't had a transaction since July 15, but I'm noticing alot of recent tranactions on factorytalk tranasaction manager.

Erland Sommarskog 132.4K Reputation points MVP Volunteer Moderator

2024-10-18T21:40:02.7+00:00

First of all, I don't anything aboiut "Rockwell factory talk". I assume that's a third-party product of some sort.

Next, there is not really any SSMS ver9. Then again, which version of SSMS you are using matters little. SSMS is only a tool to talk to SQL Server. The version of SQL Server is more interesting. Please run this query and share the results: SELECT @@version

As for your question, it's difficult to understand it. Can you illustrate with screenshots what you mean?

1 answer

Your answer

Erland Sommarskog 132.4K Reputation points MVP Volunteer Moderator

2024-10-18T21:40:02.7+00:00

First of all, I don't anything aboiut "Rockwell factory talk". I assume that's a third-party product of some sort.

Next, there is not really any SSMS ver9. Then again, which version of SSMS you are using matters little. SSMS is only a tool to talk to SQL Server. The version of SQL Server is more interesting. Please run this query and share the results: SELECT @@version

As for your question, it's difficult to understand it. Can you illustrate with screenshots what you mean?

Answer 1

Olaf Helper 47,611

noticing its only showing the fist 1000 rows.

Are you doing in SSMS a right-mouse click on the table => "Select Top 1000"? Then of course you get only the "first 1000" records.

Remove the TOP 1000.

Share via

My table wont show anymore data past the first 1000

1 answer

Your answer