none
Row Limitation RRS feed

  • Question

  • Hey Everyone, 

    When we make the data views then every time my data records gets truncated. It happens only when the no of records are more than 100000.For me it happens every time since my no of records are close to 80-90 millions. So is there any default value for this. Is there any configuration file that we can edit & change the no of records value. If anyone knows please help. Thanks in advance.

    Thanks 

    Shivam 

    Friday, February 12, 2016 12:52 PM

Answers

  • Hi Shivam,

    There are not any limitations on Number of rows on a table or set of tables. It has limitations of database of up to 10GB for SQL 2008R2 onwards.

    Regards,

    Balwant.


    Failure in Life is failure to try... PGDCA-98(South Gujarat University),MCSA (SQL 2012) , MCTS (SQL Server 2005) http://blog.vspatel.co.uk/

    Friday, February 12, 2016 12:57 PM

All replies