I don't think I explained my problem very well - plus I have now answered it myself. To clarify, my problem was that I have the name of a...

I have made the changes you suggested and it works like a charm. I will change my traps to try/catch and clean up my formatting per your good example....

I can't wait to try this. I have to wait until the job which is running now gets to a good stopping place which may be a while. ...

I found a permissions issue and thought the problem was resolved but I don't think it is. Still checking ...

Here is the script. It is still pretty complex. It was based on a script I found here:

http://www.simple-talk.com/sql/learn-sql-server/change-management-and-source-control/

My beginning adaptation of that script DOES work correctly...

Tomorrow I will prepare a mini-script I can send you. I'll pare it down to the essentials. Thanks for helping -

Judy

Well, I am back to where I started. When I change these lines and only these lines -

$scrp.Options.FileName = "$homedir\Tables\$tblname.sql"

$scrp.Script($tbl)

to this -

$tbl.Script() + "`r GO `r " | out-File...

I will do that. I thought I was covered because I thought what I had asked it to do was not to continue the script if it couldn't connect...

I'm adding to my own post here by saying that I think this may be a connectivity issue in disguise. It's not that it doesn't product output - it's...

Thank you, Rich. That's what I decided I needed to do. I was trying to avoid creating another table. I already log users deleted, by whom, date...

It is the appending part that I am having trouble with. I can send the email if my source is a variable and I simply send user::errorout. I...

There are 12 servers. For simplicity, let's say I run step 1 and step 2 for each server. If step 1 fails, I pick up the error from...

Thank you so much! It all works now. Granting the login the system administrator role was not necessary - just the Grant ALTER ANY LOGIN to xxxxx.

Thanks...

I am trying to allow a non-sysadmin user to run the create login command. Is this possible? I have done the steps in your article but my user...

I'm the original poster of this problem from a year ago. All the suggestions about trapping what is happening at the time are good. Since you know when...