title: Powershell SQL server update query
body: <p>I'm trying to connect to a Microsoft SQL Database and update any record that the changed field is = to 'x'.  I'm able to query the database but when I attempt to do an update I get this error:</p>
  
  <pre><code>Fill : Exception calling "Fill" with "1" argument(s): "Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding."
  </code></pre>
  
  <p>This is the script I'm using:</p>
  
  <pre><code>#Create SQL Connection
  $con = new-object "System.data.sqlclient.SQLconnection"
  
  #Set Connection String
  $con.ConnectionString =(“Data Source=server;Initial Catalog=IDCards;Integrated Security=SSPI”)
  $con.open()
  
  $sqlcmd = new-object "System.data.sqlclient.sqlcommand"
  $sqlcmd.connection = $con
  $sqlcmd.CommandTimeout = 600000
  #$sqlcmd.CommandText = “select * from tblPhotoID where changed = 'X'”
  $sqlcmd.CommandText = “UPDATE dbo.tblPhotoID SET Changed = '1' WHERE Changed ='X'”
  $adapter = New-Object system.data.sqlclient.sqldataadapter ($sqlcmd.CommandText, $con)
  $set = New-Object system.data.dataset
  $adapter.Fill($set)
  </code></pre>
  
  <p>There are about 4000 records that would updated currently.  The script runs about 30 secs before timing out.  I've tried increasing the command timeout and gotten the same results.</p>