Hi Guys,

I am new to the database administration game.

I encountered a dependency issue (In MSSQL 2K) when I was trying to change the datatype of a column from smalldatetime to datetime.

This is the code I use:
ALTER table AllNetCategories ALTER COLUMN actiontime datetime 
When I run the above code, the database comes back this error message
Server: Msg 5074, Level 16, State 1, Line 1
The object 'DF_AllNetCategories_ActionTime' is dependent on column 'actiontime'.
I also checked the dependency on the target table using
sp_depends AllNetCategories
and I cannot see any object name like "DF_AllNetCategories_ActionTime" dependent on it.

Can anyone please help?