skeleton567 (3/31/2014)

---

"The real divide in this nation, I feel, is income disparity; poverty isn't choosy about who it afflicts."

This whole new argument based on income disparity is mind-boggling to any...

You could create a test SSRS report, and just as a data source 'SELECT SYSTEM_USER' or some variation of http://technet.microsoft.com/en-us/library/ms191126(v=sql.105).aspx user id system variables to see what SQL (or windows)...

Megistal (3/26/2014)

---

I might not get it 100% right on this but I feel legislation are failing to this, at least from what I've seen.

Often I see that disclosing vulnerability could...

nick.latocha (3/25/2014)

---

Lets say we have a reconciliation against a 3rd party vendor where we submit sales to them.

There is a chance we can submit the same sale twice by accident....

Double check that the 2000 server (edit: database) doesn't has a case sensitive collation and the same named columns aren't just different casewise (and thus actually unique).

Also, you should try...

Be aware, if you ever type that password manager password in to some other site, then anyone who's ever taken a copy of it and gets that password can open...

I like underscores in names.

I try to create naming conventions that sort nicely also, but that goal could be counter to other concerns.

Nothing jumps out as incorrect, but since I can't recreate your exact scenario, hard to troubleshoot from here.

Anyways, I know I might be typing the obvious but if you can't...

studySQL (3/17/2014)

---

What do you do as a dba to eliminate sql injection? application code can not be changed or altered. Or if it happens, what kind of logs do you...

Sean Lange (3/4/2014)

---

Lowell (3/4/2014)

---

in a similar post a couple of years ago, i did a TSQL example that looked at the first x bytes and compared them to known values...

Maybe you could insert an extra variable that mirrors your table variable, and insert a copy of whats in the table variable you are testing into the new extra variable,...

Awesome! Glad you got it working!

Did you make the dsn a "system" dsn, ie., available to everybody (including the account that will be used to fire off xp_cmdshell)?

Is the underlying access file also available to...

awesome glad you got a solution!

Here's a sample case expression that I would start out with with a pretend join because yours was a tad confusing to me, you'll get better help by following Sean's...