Scripting Blog

A place to learn about PowerShell and share stories of automation

February 2009 - Page 2 of 4 - Scripting Blog

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

February 18, 2009 Feb 18, 2009 02/18/09
ScriptingGuy1
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 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, I am standing here ...

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

February 17, 2009 Feb 17, 2009 02/17/09
ScriptingGuy1
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 Hi GF, You need to do what? ...

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

February 16, 2009 Feb 16, 2009 02/16/09
ScriptingGuy1
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 thing for me...

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

February 12, 2009 Feb 12, 2009 02/12/09
ScriptingGuy1
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 Hi JG, "That dog won't hunt." I...

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

February 11, 2009 Feb 11, 2009 02/11/09
ScriptingGuy1
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 Policy ...