Scripting Blog [archived]

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

Hey, Scripting Guy! How Can I Tell Which Tables and Columns Are in a Database Without Opening It?

(image) Hey, Scripting Guy! Is there a way to figure out which tables and columns are in a database without having to open it up?- DT(image) (image) Hi DT, The Impressionists are back in Chicago! For the past six months, they were hibernating down in Ft. Worth, Texas, in the United States. But now they are back. In true Ferris Bueller style...

Hey, Scripting Guy! How Can I Create a Database with More Than One Table?

(image) Hey, Scripting Guy! Being able to create a database from a script is nice, and I appreciated your article yesterday. But I need to have a database with more than one table in it. Obviously this can be done, but I am at a loss as to how to go about it. I am not a real programmer; do you have any tips for me?.- GF(image) (image) Hi GF...

Hey, Scripting Guy! How Can I Use Windows PowerShell to Create an Office Access Database?

(image) Hey, Scripting Guy! I have looked everywhere, and I cannot find a script that will create a new Microsoft Office Access database, and automatically add a new table and columns to it. If you had such a thing in Windows PowerShell it would be even better. I know it is probably too much to ask, but could you, would you write such a ...

Hey, Scripting Guy! How Can I Generate a List of My Group Policy Objects?

(image) Hey, Scripting Guy! We have a number of Group Policy Objects (GPOs) that are not really doing anything. In fact, they are about as useless as an old hound dog with sinus problems. What I need is an easy way to find these old GPOs and produce a list so I can decide if I wish to delete them. Can you help me?- JG(image) (image) Hi JG...

Hey, Scripting Guy! How Can I Create New Group Policy Objects?

(image) Hey, Scripting Guy! Good morning. We are in the process of modifying our Group Policy implementation, and I anticipate having to create 15 or so new Group Policy objects. I know that I can open the Group Policy Management Console, right-click, and go through the wizard, but I would prefer to have a script that would create the Group ...