Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ilee1
Starting Member
5 Posts |
 Posted - 2007-10-05 : 01:21:46
|
Hi there,I have a problem in SQL 2005, can someone help?I happened to create a new field, lets say: sSubject with type: nvarchar(50), null.then manually I go in and add this field with data and SAVE it.For some reason, few days later the apps cannot work. And I went into DB and found out that the mentioned field contents has become "NULL".  What is going there in DB?Thanks....cheers |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-10-05 : 04:03:05
|
May be the extra magnetic field inside your PC did the trick! Seriously there are so many possibilities that one of your queries might have inadvertently changed the field contents to NULLs. You need to check all the queries/SPs which refer to this table.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-05 : 23:37:17
|
| How many rows did you insert? Does app look at same rows? |
|
|
|
|
|
|
Issue with missing field contents