I am trying to retrieve all the records of a table in MS SQL Server, it has over 120.000 records. But when I do a "Select *" statement it only returns 43093. When I enter this in the Query Analyzer it does return all the 120.000 records. How can I solve this problem?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Not getting all records of a MS SQL Server
- Thread starter Kai77
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question