|
Home > Archive > Microsoft SQL Server Desktop Engine > April 2005 > I lost my field feature like "default value"
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
I lost my field feature like "default value"
|
|
|
| I found a problem with my MSDE2000 release A, today I tried to add some data
into the DB, and it didn't work. After several tries, I figured out what
happened. My field feature ( "default value") has gone. There was no default
value at all.
This had happened before, I thought I forgot to set the default value.
Can anybody tell me what's wrong ?
Thanks in advance.
Long
| |
| Andrea Montanari 2005-04-22, 8:23 pm |
| hi,
Long wrote:
> I found a problem with my MSDE2000 release A, today I tried to add
> some data into the DB, and it didn't work. After several tries, I
> figured out what happened. My field feature ( "default value") has
> gone. There was no default value at all.
> This had happened before, I thought I forgot to set the default value.
> Can anybody tell me what's wrong ?
> Thanks in advance.
>
how is the table structure defined?
a defined dafault can not disappear, it must have been dropped some wyay,
perhaps when re-creating the base table as the result of a SELECT INTO
statement and related sp_rename... anyway it can not disapper by itself...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply
| |
|
| Hi, Andrea,
Thank you for your reply.
I didn't drop the table,and the records in the table seldom change.
Does it has anything to do with the weekly backup schedule? I remember I
once did something wrong and I had to restore the database.
Thanks for any relpy.
Long
"Andrea Montanari" wrote:
> hi,
> Long wrote:
>
> how is the table structure defined?
> a defined dafault can not disappear, it must have been dropped some wyay,
> perhaps when re-creating the base table as the result of a SELECT INTO
> statement and related sp_rename... anyway it can not disapper by itself...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>
>
|
|
|
|
|