Almost exclusively RDP, since I have to perform other tasks on the servers as well. I'm the only developer / DBA / operator in the entire shop. The machine is...

I guess I see. Of course,...

Well, yes, but that can happen even after you've created and test-restored a backup. I plan...

Okay, that makes sense. But then I don't understand what can be wrong with the backup. If I run checkDB, I know my database is good. If I back up...

Well, then why does Grant (and others) make a point of saying you should test-restore the backup? If the checksum is enough to guarantee that the backup was done correctly,...

I realize I'm getting pretty far out there with all this, but...

If the backup with checksum can look okay, but still be corrupt, couldn't restoring that failed backup also look...

gwardell (9/9/2012)

---

I worked once on a government contract where the entire application was fleshed out in a design tool. That "application" wound up being the deliverable and the application...

The two are...

Sounds nicely politically correct, however, what do you do when the users themselves don't know quite what they want? I run into this a lot - they have a vague...

jerry-621596 (8/9/2012)

---

If you are using Acess for the application side, why don't you pull the original dataset into Access and work to refine that instead of trying to track a...

Yes, it will almost always be a scan in these cases - that's the problem. I'm handling the edge cases...

Lowell (8/9/2012)

---

what about going ahead and using either a permenant or a global temp table, but adding an extra column with some identifier to the user or session, ie the...

SomewhereSomehow (8/9/2012)

---

Now I understand what are you trying to do, and my idea with temp table (even it is technically possible, and even if you'll find the way to issue...

Gazareth (8/9/2012)

---

You'd need some way in Access to execute T-SQL (or equivalent) rather than calling a proc.

I don't use Access so I've no idea if it has that ability, sorry.

e.g....

Gazareth (8/9/2012)

---

No, if you create a local temp table outside a proc, it isn't destroyed until the creating session disconnects (as it doesn't go out of scope).

So this table could...