CODEWITHSUNDEEP
sql-serverssms
aherrick
aherrick

Reputation: 20179

Sql Server Mangement Studio 2008 R2 only returns 3 records from every table and database

Alright this is killing me and I cannot figure out what is going on.

Starting today it seems if I open SSMS, right click on a table and select "New Query" then run a select start on any table it only returns 3, and only 3 records.

However if I right click on the table and run "Select top 1000 rows" it does successfully return the records.

The only difference I can see between the two is in option 2 where I "Select top 1000 rows" it runs from "localhost.master" However in the first option it runs from "localhost.DBName"

Has anyone ever seen this kind of behavior before? Is there anyway I can "reset" SSMS. I tried doing a clean repair which was successful however it has not fixed the issue.

Upvotes: 0

Views: 157

Answers (2)

Consult Yarla
Consult Yarla

Reputation: 1150

There is a setting in the SSMS that will allow to specify the number of rows for display/edit using right click on table, It is in Tools --> Options --> "SQL Server Object Explorer" --> Commands. These might have changed, please update them and try.

Also, for more details please refer to the link Useful Settings in SQL Server Management Studio

Upvotes: 1

E.J. Brennan
E.J. Brennan

Reputation: 46879

Try typing:

set rowcount 0

into SSMS and running it to reset the limit; you may have previously done a 

set rowcount 3

and forgot to undo it.

Upvotes: 0

Related Questions