Jeff Moden (9/16/2015)

---

I've always thought this whole process was a bit, um... well... stupid. If you're not happy with your job, etc, yadda, yadda, then you should be talking...

Wayne West (9/15/2015)

---

Rod at work (9/15/2015)

---

Wayne West (9/14/2015)

---

I'll be honest: I currently do not use a version of VCS. I did back in the Dos days using BRIEF, someone...

Wayne West (9/14/2015)

---

I'll be honest: I currently do not use a version of VCS. I did back in the Dos days using BRIEF, someone came out with a source...

I'd like to know how people save the stored procs, views, triggers, etc. in a VCS? Whenever I've used SSMS there wasn't any integration I could see with anything like...

OK I've found out what a format file is, and have created it using the bcp utility. (Never done that before.)

Now what I don't know how to do is not...

Would that format file be my .CSV file? And the source and destination columns would be the first row of the .CSV file? If so, then I'd better go back...

Ok Ed, I've got a question and an observation.

First the observation. I didn't know it when I wrote the SQL BULK INSERT script, but that must be run on the...

Ed Wagner (9/11/2015)

---

If this is a one-time activity, you can query the rows in SSMS and save them as a CSV file by right-clicking the results pane...Save As and select...

I believe we do have an ER diagram somewhere, but I don't maintain it. I'm a part of a bigger IT/dev group now, with more specialization. The tool they're using...

Wayne West (8/31/2015)

---

Wow, a 35,000 word article? That's a short story! It took me pretty much a full day to read it! (don't tell my boss)

It had a...

Wayne West (8/26/2015)

---

Rod, if your database's front end is Microsoft Access, or if people are using Access against it, you might want to keep it. Access likes rowversion to...

An excellent article, Steve. Like others have said I'm going to read the Bloomberg article later; can't now as I'm at work. But your article reminds me of a problem...

Late yesterday I had the same thought, Tom. i.e.: why not chance the constraint to use cascading deletes? In fact, at least from my point of view that makes more...

Jeff Moden (8/25/2015)

---

sgmunson (8/25/2015)

---

Rod at work (8/24/2015)

---

Hmmm. Thank you Grant, I really appreciate the straight forward explanation for what the rowversion/timestamp is all about. I'm working on archiving the data,...

The weird this is I tried reversing the order - i.e.: deleting the data from PharmInvOutItemPackageReceipts first, but that didn't help. I got the same error message. However you've given...