updates the next column

[indoaryaan]

I am using a SP to update a nText column. The update is fine. The next column is a DateTime column..and in few cases the datetime col gets updated to NULL. The SP does not touch the DateTime col at all. I have looked for any triggers being fired..but none seem to exist. I have run trace to check the code being executed...that looks fine too. No code touches the Datetime col. Is there anything i can do to find out what causes the upddate to NULL. Any help would be appeciated. Thanks.....

 

[JayKusch]

The table may be set up to have nulls on that column.

Thanks

J. Kusch

 

[SQLBill]

Maybe the table was created with a DEFAULT of NULL for that column. For example:


CREATE TABLE mytable
MyDate DATETIME DEFAULT NULL

-SQLBill

 

[donutman]

If the above doesn't answer the problem, how about the application? Are you using VB 6 with a connected recordset?
-Karl

 

[indoaryaan]

i have checked for defaults...none there. No i am not using VB...i have to do this in SQL. Is there a way i can capture the command / command name which kicks in the trigger / update ???

 

[SQLBill]

You could try to capture the transaction using Profiler. When setting up the trace, select Stored Procedures: SP:StmtStarting and SP:StmtCompleted, also TSQL: StmtStarting, StmtCompleted. I believe those will give you the actual statements being run. Add some of the auditing information such as logins, logouts, etc. Then filter on the database.

-SQLBill