SQL Kiwi (9/30/2011)

---

Gianluca Sartori (9/30/2011)

---

As you can see, in this case STATISTICS IO returns objects in reverse order. Is this sensible and/or guaranteed/documented? I couldn't find anything on the...

Evil Kraig F (9/30/2011)

---

Not entirely true, Gianluca. You just can't update more...

What do you mean with "data"?

Just the records you selected? Yes, they are transferred as TDS packets.

The whole table? No, it is not transferred, unless the application does things very...

You're welcome.

If you need further assistance, you can come back here and ask.

Duplicate post. Replies here: http://www.sqlservercentral.com/Forums/FindPost1183645.aspx.

Oh, I see what you mean, thanks.

Great question, Paul!

I got it wrong, as usual. 🙂

I was highly tempted to pick the correct answer based on how the hash operator works, but I suspected there was a...

Your login has network access permissions, Local System can't access UNC paths.

~Dev~ (9/30/2011)

---

You should not compare NULL with equality operators. you must use 'IS NULL' or 'IS NOT NULL' operators.

Thus (1=NULL) and (NULL=NULL) are bad operations.

Else, you may override default behavior...

SQL Kiwi (9/22/2011)

---

I did forget to...

The "Local System" account has no network access.

Either change the job owner or run the job through a proxy account.

They should return the same results. Probably you oversimplified the original issue when posting the question.

Can you post the original query and sample data?

Something like this:

DECLARE @a TABLE (

id int

)

INSERT...

SELECT A.*

FROM bulksms.tblContact AS A

CROSS APPLY...

Please forgive me if I'm wrong but... is this homework?

Seems to me that you're running the BCP command with integrated security.

In order to log on with windows authentication, the BCP process must be spawned using the windows credentials of...