ap-mode (10/17/2014)

---

Hi Everyone,

Long time lurker, first time poster. I have a simple question that has been keeping me up at night.

It's my understanding the log files are circular, in that...

If you remote desktop into the server without opening up SSMS, then try to issue the WSFTP command FROM WITHIN THE REMOTE DESKTOP, on the server - what happens?

Also -...

As I recall WSFTP uses a lot of the standard DOS errors (exit code 3 which means "Path not found"). You'd have to make sure that the paths you're...

I think you're right that it's the SQL injection checker that's firing and dropping you out. While certainly not ideal - have you tried removing the @symbol (and maybe...

They could implement a "default" WHERE clause. Our homegrown reporting solution will insert criteria to only show the last 2 months of results if nothing is passed.

The devs are...

Hmm. "exact rounding" isn't (since the purpose of rounding is to NOT use the exact value).

Just be careful with the "rule of thumb". You want to actually be aware...

Oh I have my share of those 🙂 . Don't feel that way - it's usually a matter...

where

inspection='permit' or

overdue is not null

I know this is probably incendiary, but - have you considered disabling their access through SSMS? Or - giving those users their own off-line copy of the DB?

SSMS is...

have you tried the flat file destination? lots of config options in there before you ever need scripting.

Well - to your piont about troubleshooting - for any given outbound file, I would not be looking to have BOTH involved heavily in the transformation/formatting. To Alvin's earlier...

...Unless you're calling the insert individually (i.e. once for every readerID and fileId being inserted). Is there any way to group up/batch up the inserts? Doing 1M x...

krypto69 (10/14/2014)

---

Matt Miller (#4) (10/14/2014)

---

First - one smallish comment: SQL INJECTION. This one's ripe for it. seeing the dynamic query concatenated with some input (and with the...

First - one smallish comment: SQL INJECTION. This one's ripe for it. seeing the dynamic query concatenated with some input (and with the Web APP mention in...

Sean Lange (10/10/2014)

---

Consider closely what this is doing. The return from your function is NOT an nvarchar(max). It returns a table with a single column that you are then trying...