Article ID: 928966 - View products that this article applies to.
When you try to populate a table by using a data generation plan in Microsoft Visual Studio 2005 Team Edition for Database Professionals, you may receive an error message that resembles the following:
Table <TableName> : System.Data.SqlClient.SqlError: Arithmetic overflow error converting IDENTITY to data type tinyint.
This problem occurs because Visual Studio 2005 Team Edition for Database Professionals does not validate if the number of rows that are added by the data generation plan exceeds the maximum number of rows that are permitted in an identity column.
To work around this problem, make sure that the number of rows that are added by the data generation plan does not exceed the maximum number of rows that are permitted in an identity column.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about integer data types in Microsoft SQL Server, visit the following Microsoft Developer Network (MSDN) Web site:
Steps to reproduce the problem
Article ID: 928966 - Last Review: December 13, 2006 - Revision: 1.0