Thanks for finding that. I didn't have one handy.:crazy:

Luis Cazares (8/12/2015)

---

Lynn Pettis (8/12/2015)

---

Probably, but so was his WTF in his OP and then the bashing because we didn't give...

Agreed.

With no SQL engine on C, you have your hands tied a bit more.

Powershell is an option as mentioned by gazareth.

What is the business purpose for not allowing communications directly...

Let's keep this friendly.

Let's not antagonize.

Well, if server C can see both A and B, then you can do this a number of ways.

1. Linked Servers to pull data from A to C, and then...

Hany Helmy (8/12/2015)

---

Damn :cool:...

Grant Fritchey (8/12/2015)

---

Following on ignorance, you also get laziness, misplaced priorities, complaisance (who would hack us?), even active resistance to change (although, link that back up to ignorance again) and...

GilaMonster (8/12/2015)

---

Because people who don't know what they're doing write blog posts/articles showing what little they know (eg login forms with plain text passwords and SQL injection vulnerabilities) and they...

mar.ko (8/12/2015)

---

Well guys, not one of you provided a solution.

There are two:

1) ISNULL(@ColDefaultVal,'-')

That variable was the one preventing the PRINT from executing.

2) RAISERROR ('ColDflt=%s',0,1,@ColDefaultVal);

This is even better as it indicates...

Without a datetime component in the table and without the possibility to join to another table to get that information, you are somewhat stuck.

You would need to add a column...

Nope - I have plans.

dearth

Yup, SQL injection is still serious business and still a pretty sizable problem.

Alvin Ramard (8/11/2015)

---

WTF = Where's That Fellow...