• Yeah, I was going to suggest SQLCMD as well.

    Plus, why are you manually opening all kinds of windows in SSMS to do manual updates all day long? You should be able to script out processes and schedule them with SQL Agent or set up triggers and not have to sit there manually running tons of different scripts to keep the system up.

    Also, you might look into PowerShell. It provides more programming ability without all the overhead of VB or C#.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning