What type of ODBC DSN did you actually create? File, System or User?

EDIT: And what type of OS do you have on your server? It seems to me that this...

There's no way to cause a Foreach loop to stop in the middle unless you deliberately fail it out. If you want to do that, stick a script task in...

You may have to format the Excel worksheet before loading it. If the column in question is formatted as General, you'll need to change the entire column's data type to...

A great way to impress your boss is to create a daily or weekly "Entitlement" report that documents these permissions in all environments. Have the report dumped to a secure...

Part of your problem may be the distance between data centers / server locations. Especially if they're in different domains.

Sometimes doing batches can help speed things up, but I don't...

mw112009 (2/12/2016)

---

In SSMS you can get the def of a table by:

Right Click on table, Script Table as, CREATE to, New Query Editor Window

Question1:

Is there any way I could do...

So apparently I didn't go far enough on my quotes. I was doing 4 / 5 instead of 6. At least it works now.

Thanks, everyone.

Jacob Wilkins (2/11/2016)

---

So, the trick is that in the innermost quoted command, the EXEC sp_helptext, you want single quotes around schema.object. Since it's inside a string, each of those single...

You say that as if I have a choice about what version of VS I can use at...

jasona.work (2/11/2016)

---

Yeah, this gets fun...

SSDT is the "upgraded" BIDS in 2012. In 2014, SSDT is now a completely separate download, either as a stand-alone (I hope as I just...

Grumpy DBA (2/8/2016)

---

Not exactly what you're looking for but...

Sean Lange (2/8/2016)

---

Ack what a rough start to the week. My dog went for "last outs" about midnight last night and found a skunk. This is the second time in...

Heading to Seattle soon and wondering if MS gives campus tours or not. Because... why not?

Anyone know if they do?

Alvin Ramard (2/5/2016)

---

SQLRNNR (2/5/2016)

---

WayneS (2/5/2016)

---

Lynn Pettis (2/5/2016)

---

jasona.work (2/5/2016)

---

So the other day I was paying bills, and got curious about my electric bill. It was easily 2x what it had...

Luis Cazares (2/4/2016)

---

Phil Parkin (2/4/2016)

---

Grant Fritchey (2/4/2016)

---

Grumpy DBA (2/4/2016)

---

In the past I worked with a couple developers (SQL and Oracle) who used Select * quite often. At every code...