CODEWITHSUNDEEP
sqlsql-server
Vikas Lalwani
Vikas Lalwani

Reputation: 1061

SQL Server 2012 Management Studio not returning more than 10,000 rows

I am running a simple query like 

SELECT *
FROM [LyncConversationDetail].[dbo].[MessageDetails] 
WHERE ProjectId = '13'

but I am not getting more than 10,000 rows as a result, not sure what am I missing here as I don't have much knowledge in this. Is there any SQL Server setting for max row count? Or is it dependent on something else?

Upvotes: 0

Views: 171

Answers (1)

Mat
Mat

Reputation: 313

Try to check how many rows is in Your table.

SELECT count(*)
FROM [LyncConversationDetail].[dbo].[MessageDetails] where ProjectId='13'

Upvotes: 2

Related Questions