Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
johnstern
Yak Posting Veteran
67 Posts |
 Posted - 2007-05-09 : 13:06:21
|
| is there a setting in Query Analyzer that will let me bring all the records right it only shows up to 4282 records |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-09 : 13:19:09
|
| There is a setting in Query Analyzer, but the default is 0 which means bring everything back that matches the query. The setting is in Tools..Options..Connection Properties. What is your set rowcount set to?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-05-09 : 13:20:14
|
| I think there is a setting to control the number of records returned, but I no longer have QA installed so I cannot look. But, you might try executing SET ROWCOUNT 0 to make sure it was not set previously. |
|
|
|
johnstern
Yak Posting Veteran
67 Posts |
Posted - 2007-05-09 : 14:05:43
|
| it shows set to zero ... and I execute SET ROWCOUNT 0 but still no luck ... in enterprise works fine |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-05-09 : 14:07:29
|
| Maybe it would help if you explain a little more what you are doing. Are you executing a SQL statement? Browsing a table? How do you know for sure how many rows are in the table and that you are not getting them all?- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-09 : 14:07:36
|
| Please post your query.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
johnstern
Yak Posting Veteran
67 Posts |
Posted - 2007-05-09 : 14:54:51
|
| it was just a simple query SELECT * FROM FM_TOC_STATE I restarted my computer and seems like everything is ok now ... not sure exacly what happened |
|
|
|
|
|
|
Query Analyzer only brings 4282 records