>I had a datetime field in the access95 table with the default value
>After upsizing the table to MSSql6.5 the default value is STILL inserted
>theres NO entry in the default of the SQL-tabledefinition and theres
>So where does the SqlServer take the default value from?
>What am i missing?
I don't have an answer on your second question and I'm not sure that I have a
solution for the first, but here is my suggestion. If your still in fact
getting the default inserted but there isn't a default in the table definition
it just means that there is no DEFAULT defined, which means that I would assume
there is a DEFAULT CONSTRAINT that was created instead. DEFAULT CONSTRAINTS
aren't listed in the table definition, but would be shown if you used the
generate script utility within the enterprise manager. One or the other is
still in effect. Sooo, take a look at your constraints and take a look at your
defaults (from the enterprise manager choose MANAGE and then DEFAULTS) and it's
got to be in one of those two areas to the best of my knowledge.
Hope this helps,
Adam P. Cassidy