Register a free account today to become a member!
Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

n00b SQL Server 2008 question!

Darren S

ClioSport Club Member
How do you view the next 200 records within SQL Server Management Studio? It seems MSoft has limited it to that in order to stop the firehose mode of earlier editions - which is fair enough.

But I'm a SQL novice and a little bit stuck - lol! :eek:

  Golf Mk6 Oil Burner
Just open up a new query mate ...

USE [Database_Name]

FROM tblTable_Name
lol I was having a play the other day and was thinking wtf.

Thing that confused me was the edit top 200 rows, I wanted to get more out lol.

All I had to do was get the sql pane up and just remove the bit that limits it.