I prefer the join conditions.

update x

set date = getdate()

from inserted i

where i.PK = x.PK

Gail, not sure if this is a language thing, seeing brackets in your post...

As a technology, nothing it wrong with Access. It fits in places, but it also is deployed to many people that get themselves into trouble with databases. In many ways...

True, you have to do the backup, but you don't have to stop work while you do it and can keep the DB up.

If that doesn't matter, detach will...

Good idea, I'll add one somewhere. Despite my desire to have less forums, this makes some sense.

You'd think I'd be used to typing 2008 by now.

The core of 2008 is the same as 2005.

I'd like to think that's the minority, but who knows. When you're struggling to find a job, you can really be driven to do things. At least he's asking. Hopefully...

There's a nice dojo in Seattle I went to with Gail. Likely that will be a yearly stop at PASS. Anyone's welcome to join us.

David,

That's a good point. I think that's what I've learned to do over time just for expediancy's sake.

I'm not sure one is much faster than the other, but you need to determine why you can't get a backup. What is the error?

If you detach/attach, be sure you...

What was the error?

Likely the installer doesn't recognize W2K8, but I bet this will work fine. This used to occur with SQL 65 on W2K and SQL 7 on W2k3,...

They're still going. Might be an update to a filter on your end.

I don't think 2005 has any advantages over 2008. 2008 is essentially a 2nd version of 2005 with features bolted on. Now I wouldn't necessarily use some of those new...

And Gail wears a nice, pressed hakima for throwing her favorite editor around 🙂

I've honestly stopped checking this at many servers since they're usually > 90%. However I have seen it in the 80s or lower and more memory almost always solves this...

Paul, I tend to agree with that. MS is open in some ways, but very closed in others.

Let us know there's something in the works. In this case, I'm not...