Matt Miller (#4) (2/1/2010)

---

I'm a little late to the party, but worrying about the phantom copy of the record in the DB when your using CLASSIC ASP to access the...

Lowell (2/1/2010)

---

Steve it sounds like you could prevent it to me.

If you can detect data that does not belong AFTER the fact, you could add filters in the application or...

Lynn Pettis (2/1/2010)

---

To me it looks like an application issue. Unfortunatley, it appears it allows the wrong data to be entered into the wrong database. It maybe better...

So does anyone have any recommendations? The requirement would read like "Given one or more records in SQL Server 2008, these records need to be completely removed from the...

Unfortunately because of security rules, it doesn't work this way. Anyway, the...

OK, so.....

(A) If I change the recovery model from FULL to SIMPLE, then perform the DELETE will the delete action not be logged? I can then change recovery...

We recently upgraded all our SQL Server instances from 2000 to 2008, so my goal (as a developer, not a DBA) is pretty simple -- to learn more about the...

If I as a developer have to provide all that information, just let me do it in the first place! 🙂

Fortunately that's how it works here. Our DBAs are...

Hmmm... that would be interesting! In my organization, the former...

Not 100% sure about server passwords, but here on our US Air Force networks we have to change our admin account's passwords every 90 days. But get this --...

Just an external USB HDD connected to my desktop PC. I use SyncBackPro to back up all of the important folders to the HDD nightly. I also have...

We will migrate most of our operational SQL Servers to 2008 within the next 12 months. They're all still on SQL 2000. Our first migration effort was, believe...

I'm working on a classified network, so it's kind of hard to show real world examples. I tried to give a simple example that represented my problem...

What I actually...

Oh yeah, first thing I tried. Zero rows returned... This is baffling.

How about making the score very simple and straightforward -- 2 points for a correct answer, 0 for a wrong answer. Takes "weighting" a question out of the loop....