jasongaylord

Function Get-ADComputerCDRomInfo
{
    # Search Active Directory for computers
    ([adsisearcher]"objectcategory=computer").findall() | ForEach-Object {
        # Set computer name
        $c = ([adsi]$_.path).Name;

        # Function variables
        $deviceId = ""
        $volumeName = ""

jasongaylord

-- Assume that we have a table that tracks the days off. We'll define it here
-- when actually we'd be pulling this from our connection.
declare @myDaysOff table
(
  dayOff datetime
)

-- Let's seed this table
insert into @myDaysOff (dayOff)
values ('2/20/2013'), ('2/27/2013'), ('3/2/2013'), ('3/3/2013')

jasongaylord

declare @cmd varchar(4000)
declare cmds cursor for 
    Select 'drop table [' + Table_Name + ']'
    From INFORMATION_SCHEMA.TABLES
    Where Table_Name like 'prefix%'

open cmds

while 1=1
    begin

jasongaylord

namespace TestTaskFactory
{
    partial class MainForm
    {
        /// <summary>
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components = null;

        /// <summary>