You might also want to check BOL for information on varchar and nvarchar. nVarchar has a max length of 4000 characters as it requires 2 bytes for each character. If...

Would you please post your DDL, and the statements you are using to alter the columns.

Thanks

Mike

OOPS , sorry. This may help.

Mike

From BOL

ALTER COLUMN

Specifies that the given column is to be changed or altered. ALTER COLUMN is not allowed if the compatibility level is 65...

Ah I can not seem to be able to find the cite as the search function is only giving me the last 50 hits. But of interest I did find...

Ok Remi I will dummy up some number for you. Actually the run faster statement came from on of the big brains and...

Brenden use < and > rather than between it will solve your problem and run faster as well.

[edit added an example showing that you need to use date add to...

Check BOL under modfying Default definitions. The short answer is that you can not change a column that has a data type of text.

HTH

Mike 

When you don’t have a straight man you have to work a little harder to set things up. And we all know how you like...

David I agree that much of this discussion is based on semantics and your proposal "that any logic, the avoidance of which may produce rows in the database which do not reflect...

Chris after reading many of your post I would not have guessed that english was not your first language.

Mike

Chris the problem is that it coult be mis-interpreted. As written it is correct but could be confusing in this context.

Mike

Do shcools and colleges really have a first and last name.

Mike

/*

You need to establish the relationships between each table and then use a foreign key to

tie the two tables together.

Assuming that Colleges have schools you will need to add a...

Actually I think during a rant about a client was my missing the Kill command in C and you accused me of being blood thirsty. Killing a file or table...

Mgyar, sushila is right on the money. A new Thread starting with building your tables is the way to go. Once you have established the tables and the relationships building...