@TylerH You need to list out the columns, so that SQL Server knows which values correspond to which columns (and thus allowing your default constraint to work). INSERT INTO TAW_Redirect_Log (Username, Redirected) VALUES ('test', 0);
@JoshDarnell Thanks. Any idea why I don't need to do enumerate the column for that one and not for the identity column? I guess the identity column is special that way?
@TylerH Identity values cannot be set unless the table is set to receive it via the appropriate SET command. The system will generated the next* identity value for you, there is no need to give it one. If you do, it'll error unless the aforementioned SET command had been run.
* Identity values may not be sequential depending on various system configurations, settings, and operational happenings
