Results 1 to 1 of 1
Sep 16, 2007, 17:56 #1
- Join Date
- Aug 2007
- 0 Post(s)
- 0 Thread(s)
Newbie encounts DF_TableName_ColumnName errors
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 Go
Server: Msg 5074, Level 16, State 1, Line 1
The object 'DF_AllNetCategories_ActionTime' is dependent on column 'actiontime'.
Can anyone please help?