This is one of the main reasons you use roles. So you don't mess with this every time you add a user.

Correct, Tom. Thanks for that note. A transaction is required.

Thanks for all the great comments. We are not necessarily looking to put up more ads, but rather find other ways to interact with people.

I'll discuss this with my team...

Can you list exactly what is in the connection dialog?

Gail,

where was that from? It's interesting, and worth a little writing. I certainly have felt that way sometimes. Someone pinged me this weekend with an "urgent" thread. I replied that...

It's a self join, using the left outer join, to get one version of the table, and a second version of the table matching up the IDs, but off by...

that's annoying. I hope people don't answer them, and that was what I was worried with the #sqlhelp tag.

I do surface some interesting discussions on Twitter, but try not to...

Nebraska gets that great College World Series. Need to pop over some year and see it.

Excellent, thanks for the update and glad something is working for you.

I tend to agree with Paul. I think users, or non-qualified people setting up DB servers get into trouble. If It is too busy, they ought to have a document...

And once again, I'm lost.

You need how many CPUs you need. Depends on load, and the performance you need from them.

I'm not 100% sure of all the places where ftp returns 1, but I think a "quit" or a "remote closed" will not force an error. I think only of...

You can shut down the services for the two unneeded instances in the Control Panel | Servers, and set their startup to "manual".

The problem is that ftp opens its own shell. It allows you to re-enter the password (or user), when the connection fails.

You might look at using the SSIS tasks...