How about the log?

Apr 1, 2015 at 3:54 PM
Thanks much for the tool.
I am trying it now.
Is there a way to put the execution log to a file.

Because when I ran it in Powershell, the screen looks like an red error, and exited out so quickly, I cannot see the error, also in the log table in the database I don't find one record that has error.
I know there is an error, for some tables are not created

Thanks,
Coordinator
Apr 2, 2015 at 6:15 PM
you can use start-transcript stop-transcript or pipe the output to a .txt file. Something like

RunMD3.ps1 -ServerName "yadda" > output.txt
Coordinator
Apr 2, 2015 at 6:19 PM
btw, that usually means you didn't set-executionpolicy first or else it's something with the powershell environment in general. I can't think of what that would be though. Maybe sql drivers aren't installed or something? I haven't seen that happen in a very long time. Email me if needed dave at davewentzel dot com.