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 |
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
 Posted - 2011-06-01 : 18:51:00
|
| Msg 5074, Level 16, State 1, Line 1The index 'SQl_FIX_IDX01' is dependent on column 'FixTranID'.Msg 4922, Level 16, State 9, Line 1ALTER TABLE DROP COLUMN FixTranID failed because one or more objects access this column.This is the error. Can you specify what would be the solution.Many Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-06-01 : 19:40:44
|
Thanks Tara for exclusive reply  But I have executed the above statements as indicated in the first but while adding them to the rest of the columns it complains.Which is I have dropped the index and then dropped the column - success;then I have to add this index to work since this index 'SQl_FIX_IDX01' has other columns being supported. while re-adding these columns it complains.I have re-created the same index on the columns excluding the column that was NOW dropped, so I have to add the same index for the rest of the columns then it is complaining unable to add them.Thnaks for your patience in reading. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
dbalearner
Constraint Violating Yak Guru
272 Posts |
Posted - 2011-06-01 : 19:59:30
|
| Thanks Tara I found the Error as this is inter joined with other Columns as they need to be dropped then altogether RECREATE worked out.Many Thanks |
|
|
|
|
|
|
Drop Existing Column on Database