Thanks, someone else was able to drop it - I'm not yet sure how, though.

What version of Management Studio is the user using? Is it older than the version of the server she is connecting to?

Scott Coleman (8/19/2014)

---

In the data flow task, bulk insert is enabled by the properties of the destination component. An OLEDB destination should use a data access mode of "Table...

Well, I was afraid of that lol. Thanks though!

Thanks. This issue came up because of the row limits per worksheet, but after looking into it more, it was the 2007 version that increased the limit.

I'd be interested to see an example of a row that is returned using the single statement that is not returned when the statements are separated.

As has been mentioned, that...

Ok, after some searching I found out that I may need a certain version of a certain DLL.

Does anyone know where I can find this:

stardds.dll

version:

2000.80.2151.0, Size 172KB, Date...

bump

To answer the questions:

Regarding Collation: The same collation is used for every server and every database involved - SQL_Latin1_General_CP1_CI_AS (case insensitive)

Regarding "Require distributed transactions for server-to-server communication":

This is not...

Hi, this problem has been popping up again in multiple places. It's happening on both SQL 2008 and 2008 R2, and also in queries that used to work.

Is this a...

No, there is no trigger.

Also I was wrong about one other thing, this query is new and never...

bump

After looking into this more I found out that the server people were incorrect... the change DID fix the problem, and the messages they saw were from BEFORE I made...

bump