You need to select the option that allows a row-terminator. I don't remember what it's called, but it might be "flat file ragged right" or something like that. ...

Build a table that lists your servers, step through it and get the data. Looks like that's all you're going to be able to do.

I don't think you can.

I must be misreading your original post. It seemed there that you didn't want to step into it from Visual Studio. What am I misunderstanding here?

You don't want to move system databases from one server to another. You may want to move data from the system databases on one server to the other server,...

Depends on what you mean by a breakpoint. You can always add return/print/raiserror/insert commands into a proc, and follow them with "return", which will stop the proc at that...

I don't know of a way to hide them. Unless it's for security reasons, organizing them adequately should make that unnecessary anyway.

Perhaps you should start the naming convention with...

Is the file set up so that the lines that begin with PI belong to the preceding line that begins with PE? Is that what you mean by hierarchical...

I think you do.

I think RedGate has a product that allows you to run scripts against collections of servers. Check them out, see if that will help you get this done.

SSIS can send e-mails on its own, but I usually find DBMail easier to use.

Depending on what you want in the e-mail, you could start the proc with "if exists...

Between always has to have the lower number first. -60 is lower than -31.

Edit: Lynn's post wasn't up when I first looked at this. Ignore me on this...

Can't do folders. What I do is name them based on what database or server-wide task they are mainly working on.

For example, if I have a Sales database, and...

Should be fine. After all, finding out whether it will work in production is what test servers are all about.

Have you tried querying tables in other databases than default? I think it might just show the default ones, but you should be able to query other ones.