1. Yes, you can.

2. If you have a valid business scenario for that, why not?

3. Yes.

4. There are two DB engines running at the same time. So you can have...

Thanks for the question.

What if you connect the first FELC with the second one using a precedence constraint? Does it work then?

Is it possible to post the CTE itself?

Great article! It helped me solve my linked server problem. (as for some reason the Microsoft OLE DB provider for DB2 didn't want to run InProcess. The bastard :-D)

But so...

Why won't you read the Self-paced training kit for 70-448? It contains (roughly) all the information you need.

Oh for f*ck's sake! (excuse my language)

I have found the issue.

It's a combination of two things:

First of all, the driver needs to be executed out of process. So thanks Gianluca...

Ugh. Another copyright violation.

http://www.sqlservercentral.com/Forums/Topic1150675-391-1.aspx?Update=1

Original article:

http://www.databasejournal.com/features/mssql/sql-server-index-t-sql-statements.html

Ignacio A. Salom Rangel (7/29/2011)

---

Koen Verbeeck (7/28/2011)

---

Ignacio A. Salom Rangel (7/28/2011)

---

Try choosing as provider "Microsoft OLE DB Provider for ODBC Drivers"

Also try setting the "collation compatible" value to 'false'. Check...

Peter Brinkhaus (7/28/2011)

---

Maybe a silly idea, but can it have anything to do your 32-bit/64-bit SQL Server/Windows environment. I lately got a new laptop and moved from Windows XP (32-bit)/SQL...

Both suggestions didn't work, unfortunately.

Well Jeff, I voted for you at the Exceptional DBA awards.

Not only because you are the only one I know from that list, but also because of your amazing work...

Gianluca Sartori (7/28/2011)

---

I have found that SSIS ignores the settings in the UDL file and requires entering ALL the connection parameters in the connection properties.

SQL Server has always been more...

Here you go:

/****** Object: LinkedServer [LINKED_ODBC_VILLANEXT] ...

Further investigation leads to the fact that I get the same error in the .udl file if I do not use the IP-adres in the TCPIP configuration.

However, I did provide...