Scripting Blog

A place to learn about PowerShell and share stories of automation

How Can I Delete a Record From a Disconnected Recordset?

Hey, Scripting Guy! How can I delete a record – or a set of records – from a disconnected recordset?-- SM eHy sm.,. Sorry; let’s try that again: Hey, SM. We apologize for the poor typing the first time around; the Scripting Guy who writes this column is trying to adjust to typing with just one hand and just one eye. Last night this ...

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

Hey, Scripting Guy! How can I tell whether a specified table exists in a SQL Server database?-- LL 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 way, who else out there hates the ...

How Can I Use Windows PowerShell to Pull Records From a Microsoft Access Database?

Hey, Scripting Guy! How can I use Windows PowerShell to pull records from a Microsoft Access database?-- SB Hey, SB. You know, you’re lucky to get this question answered; after all, this looks as though it’s going to be the very last Hey, Scripting Guy! column ever. To be honest, that came as a bit of a surprise to us, too: we hadn’t ...

How Can I Get a List of All the Databases on a SQL Server Computer?

Hey, Scripting Guy! How can I get a list of all the databases on a SQL Server computer?-- ER Hey, ER. Before we answer your question, we’d like to take a moment to offer our opinions on all the major – and controversial – issues of the day. We can do that because the Scripting Editor is on vacation and, well, you know what they say: ...

How Can I List All the Tables in an Access Database?

Hey, Scripting Guy! How can I list all the tables in an Access database?-- KW Hey, KW. You know, the best part about writing a daily column on system administration scripting is that people only see the finished result; they never see all the detours, dead-ends, and other frustrations we go through in order to produce that column. For ...

Feedback usabilla icon