Seth has a good explanation, though I don't know I'd assume a trigger is being used. A stored proc can do this well.

The issue is you can't turn off encryption...

distinct won't just look at the productID. How can the engine tell which row to discard if it does? Is it the row with the lower price? The higher one?

You...

Robert Domitz (5/30/2012)

---

I, for one, am a programmer: my expertise is in designing and building software. I am not a writer, nor do I aspire to be one....

I hope people aren't rating the article down because it uses FTP and not SFTP. That's what SSIS provides, and we wanted to give a tutorial on how to use...

you are welcome.

SP4 is pretty stable, and should be fine. Note that there are some post-SP4 patches that you might want to apply as well as a few are...

We had a speech at an event yesterday from the American Legion post here in town that addressed this. It is happy so...

Back up everything. Are you looking to patch Windows, SQL, or both? What patches?

I wouldn't call SQL 2000 old or fragile.

If you're really worried, I'd do a P2V migration...

There isn't a 64bit disk file and a 32 bit disk file. They are the same.

detach/attach or backup/restore as Lynn noted.

A couple things.

First, glad things cleaned up for you.

Second, if you shrink the database, you may undo all the work you did in rebuilding the clustered index to remove fragmentation....

Second vote here for DBCC CHECKDB. You cannot prevent corruption, so you need to run this regularly. If you can't do it every day, do it every week.

The checking, was...

The question had been corrected to note diff, but not full. I'll award back points as this was a tricky question with poor wording.

This isn't necessarily true....

stephanie.sullivan (5/29/2012)

---

IceDread (5/29/2012)

---

Most of you on this board is in the u.s. I believe however, and my gut feeling is that companies does not compete over workforce like this and...

Brandie Tarvin (5/29/2012)

---

We don't give Devs more than db_owner in the databases they need to have. For one, we do have a DBA admin only database that we develop code...

LogMeIn is one I've seen quite a few people using

http://itunes.apple.com/us/app/logmein/id479229407?gclid=CN-Dw4Two7ACFQcEnQodA048Xw&ls=1&mt=8&ef_id=94ZOuF@qoBQAAMPh:20120528210005:s