[Solved] Problem with static data when generating new DB

Apr 8, 2010 at 10:13 AM

Hi,

When I try to generate the model in a new DB , i have following messages :

System.Data.SqlClient.SqlException: String or binary data would be truncated.
String or binary data would be truncated.

....
The statement has been terminated.

 

When I Comment the static data insertion in CreateData.SQL all is working fine.

When I execute (copy-paste) each INSERT statement in SQLServer Magagement Studio, each statement is executed well.

But when I take the entire code of CreateData.SQL and paste it in a query, I have same error in Management Studio :

Msg 8152, Level 16, State 14, Line 5
String or binary data would be truncated.
The statement has been terminated.

Any idea why ? (I presume maybe a CR/LF problem or something like that)

 

 

Apr 8, 2010 at 10:18 AM

OK Stupid  I am .... My Name column in type table was varchar(1) ....

*slap*