You do know that the NOLOCK hint on the update is ignored, right?

Forgetting your problem at the moment, let me get this straight; database using full recovery model, daily full backups, no transaction log backups? You do realize that the transaction...

Nevermind, clicked wrong link.

If it can be done transparently at the database level there may be a better chance of developers making use of the technology when it is needed without specialized coding.

I could see developers writing client apps that using Compact and Express editions for holding data in flight locally. TDE may be necessary if those apps hold critical data,...

Joe-420121 (12/21/2009)

---

1. The table has only 4 coulmmns, no FK, constrains etc.

2. The table is used 24 hours, and about 2000 users use it all the time.

3. When I use...

Worked for me when I ran it in SSMS. What error did you get?

Do you have any transaction log and/or differential backups between the previous full backup and this one that appears to be corrupt?

Join me you may, comfortable in the...

Possibly. What is the recover model of the database?

Well, at previous employer we...

You may not want to hear this, but I think your backup file is hosed.

Do you have a previous backup file and differential/transaction log backup files?

CirquedeSQLeil (12/21/2009)

---

Sounds like a riddle - are you plucking petals from a flower as you count the ways? ...

Try this:

select

ID,

case when isnull(Date1,0) < isnull(Date2,0) then Date2 else Date1 end as TheDate

from

dbo.mytable;

Jack Corbett (12/21/2009)

---

Happens all the time, no worries.

YOu could use the second suggestion, have a GMT offset column that is tinyint. So if your offset is 5 (EST) you'd...