Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2013-02-14 : 10:25:44
|
| i have table :id identity int PK,data nvarchar(200) nulli want to change it to nvarchar(800)but the problem is the index that can't be created any solution for this? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-14 : 10:32:12
|
| None that I know of. The only options I can think of are to accept the max width (450), or, if you don't really need the unicode capability, to change the data type to VARCHAR(800). |
 |
|
|
|
|
|
change column size