According to the MSDN, in SQL Server 2000
"When you select a data type, length is defined automatically. You can increase or decrease the length property only for a column with a data type of binary, char, nchar, varbinary, varchar, or nvarchar. For columns with other data types, the length is derived from the data type and cannot be changed. If the new specified length is smaller than the original column length, all values in the column that exceed the new length are truncated without any warning. It is not possible to change the length of a column defined with a PRIMARY KEY or FOREIGN KEY constraint."
But when I try to change the column length, I get a validation warning in EM, or "String or binary data would be truncated. The statement has been terminated." in Query Analyzer. So is my configuration wrong or the statement wrong or I have to SET ANSI_WARNINGS OFF but anyway, there is a warning, no matter it shows or not.
warning when altering the column length
Hot Topic
- Usage-based optimization in AS 2005
- How Can I generate a rdl file from a mdx query in VB.net or C#.net?
- CLR trigger in another schema
- How to display group footer at end of the page
- Two column report page break issue
- Encryption Best-Practices
- Script Task scripting help
- How to insert a record in the middle of a DB
- Date Conversion
- Redudant Data on a table column...
SQL Server
- Unable to run "Management Studio(ssmsee.exe)" for Sql Express edition
- SQL Server 2005 uninstall problem
- Default Values properties (table level) not working.
- Calculated Measures using AMO
- Directory and file names - case sensitivity
- Mutli development on Analysis service
- SQL Server 2005, Parameterized Filter: Snapshot could not be applied
- report viewer conrtol problem
- SSEM - How do you connect to an MDF file?
- Can I write SQL 2000 databases with SQL Server 2005?
warning when altering the column length
IvanMorales