March 4, 2015 at 6:05 am
In my SSMS,
if i run below query it returns only 6 records.although table has more than 61 records.
if i do right click for same table and select top 1000 rows then it returns all rows.
SELECT TOP 1000 [ClientID]
,[ClientName]
,[IsActive]
,[ContactNumber]
,[ContactNumberType]
,[AuthorizedOfficer]
,[DailyContactPerson]
,[AboutCompany]
,[CompanyURL]
,[WorkSpaceID]
FROM [ClientMaster]
In addition EXEC sp_helptext procname also returns only first 6 rows part ,not more then that.if i make it right click and modify i can see whole procedure.
what went wrong here 🙁 , i have checked setting for Tools-->option-->queryresult seems fine.
what i need to check ? same problem in grid result view and text result view.
Thanks..
March 4, 2015 at 6:23 am
Options -> Query Execution -> SQL Server -> General -> SET ROWCOUNT
Default value should be 0
March 4, 2015 at 8:39 pm
Thanks a lot Kutang Pan ..
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply