Jan Van der Eecken (8/15/2013)

---

jasona.work (8/15/2013)

---

Jan Van der Eecken (8/15/2013)

---

jasona.work (8/15/2013)

---

Jan Van der Eecken (8/14/2013)

---

jasona.work (8/14/2013)

---

Ed Wagner (8/14/2013)

---

jasona.work (8/14/2013)

---

Ah, so much fun being on a contract job...

"We've got a bunch...

Death Magnetic

I look at the tables and see the layout and relationships in my head. It helps if foreign keys are created, but that's not always so. With that,...

Gail - I didn't think anyone on planet earth had a version of UltraEdit as old as mine, but you do. I used the 11.0a from 2005 for years...

This is a great way to learn what SQL the GUI is generating and firing, but consider taking it to the next step and checking out the commands on MSDN....

That's my mistake. For some reason, I read your post and thought "multiple servers". Sorry about that.

To run a single script against multiple databases, you'll need to create...

If you use SSMS and use the Registered Servers tab to keep your connections organized, it does support this. Create a group (using New Server Group) and then add...

Vice

jasona.work (8/14/2013)

---

Ah, so much fun being on a contract job...

"We've got a bunch of hours to spare, do you want to work 9-10 hour days for the next 6 weeks?"

Of...

cdl_9009 (8/14/2013)

---

If I disable the trigger on the table in the Object Explorer, it will run fine. I just need to figure out a way to put this is...

Good point, Gail, thank you. I'd not even considered the possibility of a heap.

Welcome to the SSC discussion forum!

Can you disable triggers? Yes. Should you? That depends. You want to be sure you understand the reason for it being there before...

HanShi is exactly correct. My question is why you'd need to have inserted rows in a particular order. I can definitely see the case where you have time-sensitive...

Koen Verbeeck (8/14/2013)

---

And this post marks my 10,000th one on SSC! 😎 😎 :w00t: (and some of them were actually useful!)

Now that I'm one of the big boyz and Grant...

Sean Lange (8/13/2013)

---

Ed Wagner (8/13/2013)

---

jasona.work (8/13/2013)

---

Oh what a fun little car the BRZ is!

The last time I was in a car that felt this sure-footed on the road, was a...