invoke-sqlcmd timeout

• joujousagem2006 1602

  SSCommitted

  Points: 1779

  More actions

  September 18, 2018 at 3:21 am

  #415656

  Hi everybody
  Who can help me on invoke-sqlcmd-level timestamp 
  i tried it with invoke-sqlcmd2 but I still have pb

  
  thanks

• SQLPirate

  SSCrazy

  Points: 2880

  More actions

  September 21, 2018 at 10:12 am

  #2006605

  What's the actual invoke-sqlcmd call that you're making - it's not shown in the image you provided. Also, what do you have set for your -QueryTimeout value? Is it possible you're attempting to connect to a server that doesn't exist or one that doesn't accept connections? Have you tried making the invoke-sqlcmd connection with just a simple query to just validate that the connection works?