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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2009-10-13 : 02:52:38
|
| when i executed the script finally i am getting this messgeThe query has exceeded the maximum number of result sets that can be displayed in the results grid. Only the first 100 result sets are displayed in the grid.and dis palying the only 100 results only i want to see all the results can do this in sql server |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-10-13 : 03:17:04
|
You can change to 'results to text' or you can use the old Query Analizer from SQL2000.No other chance I think.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
Can we increse the number of result sets in grid