Tnx for answering, it works indeed.

Tnx for answering and tnx for the heads-up, John. It makes things clearer indeed.

Tnx for answering, and apologies for the confusion: it is as Ignacio explains, I used the Dutch equivalent of DTAP.

Tnx for answering, I don't know if this is what I am looking for. I can find a relation in BOL between Data Collection and this dcexec utility

I have this...

I have mixed feelings about this feature. When I first read about contained DB's I felt excited, because the explanation was about a lot more then just about the ease...

I am hi-jacking this thread. I have a similar problem as srivasuk described: I have a Windows global admin account under which all SQL Processen run. I receive the same...

Tnx, I figured that much, but it is good to read confirmatiuon.

Problem is solved with an EXCPT construction.

Tnx for answering.

Interesting, these challenges, but needing to sign-up to another website, no.

I'm a bit late at this party, I know, but still:

There is NO way then to get total drive space from tsql alone? We need SOME info from outside SQL...

Tnx for answering all, very useful info in these links, I can work with that.

Ah, I just found out and wanted to add it as a comment to my question.

Tnx for answering though.

This is the first step mentioned in said article...

1. Create linked servers in each server pointing to your central repository

But you point me to a mistake: I have linked servers...

Well, problem seems solved, but the question remains. When I use COLLATE DATABASE_DEFAULT The query is executed without a problem. Why I receive the the error when I use COLLATE...

Tnx for answering.

I skipped the AS clause, but the error stays the same, as expected. As I mentioned earlier, this error pops up when I run the query against a...