$machine = @WKSTA
$Extension = "999"
$UsersKey = @USERID
$Active = "N"
$Clientkey="NULL"
$cnstring = 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=sa;Initial Catalog=Database1;Data Source=SQLServer6;Password='
$cmdtext = "SELECT * FROM XXXWorkstation where workstationkey = '" + $machine + "'"
$cn = CreateObject("adodb.connection")
$cmd = CreateObject("adodb.command")
$cn.connectionstring = $cnstring
$cn.Open
$cmd.activeconnection = $cn
$cmd.commandtext = $cmdtext
$rs = CreateObject("adodb.recordset")
$rs.cursortype = 3
$rs.locktype = 3
$rs.Open($cmd)
$rs.Fields.Item("Extension").Value = $Extension
$rs.Fields.Item("MachineKey").Value = $MachineKey
$rs.Fields.Item("UsersKey").Value = $UsersKey
$rs.Fields.Item("Active").Value = $Active
$rs.Fields.Item("Clientkey").Value = $Clientkey
$rs.Update
$rs.Close
$cn.Close