Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

How Can I Provide a Visual Indicator When Copying Files?

(image) Hey, Scripting Guy! How can I provide a visual indicator of some kind when copying a large file or large set of files?-- SK(image) (image) (image) Hey, SK. Before we do anything else we should note that the Scripting Guys – or at least the Scripting Guy who writes this column – don’t believe in moral victories. It’s nice ...

How Can I Compact an Access Database?

(image) Hey, Scripting Guy! How can I compact an Access database using a script?-- DA(image) (image) (image) Hey, DA. We have to tell you the truth: we are thrilled and excited about getting the chance to answer your scripting question. To be honest, that isn’t always the case, most days we’d look at a question like this and think, “...

How Can I Pass a Drive Letter From a Script to the Command Shell?

(image) Hey, Scripting Guy! How can I pass the drive letter of a drive from a VBScript script to the command shell that called that script?-- JF(image) (image) (image) Hey, JF. You know, as kids grow up they pass through a phase where they believe that their parents are capable of doing – and of fixing – anything. Admittedly, children ...

How Can I Tell Whether a Specified Table Exists in a SQL Server Database?

(image) Hey, Scripting Guy! How can I tell whether a specified table exists in a SQL Server database?-- LL(image) (image) (image) Hey, LL. Well, as it turns out it’s absolutely impossible to tell whether a specified table exists in a SQL Server database. So, sorry, time to go back to watching the Major League Baseball playoffs. By the ...

How Can I Monitor for the Creation of Different Processes?

(image) Hey, Scripting Guy! How can I use one script to monitor for the creation of four or five different processes?-- BC(image) (image) (image) Hey, BC. You know, it’s too bad you didn’t ask how you could monitor four or five TV shows at the same time. Had you done that we would have had the perfect answer for you: get yourself a ...