Set Showplan_xml Problem

• gaurangtalwadkar

  SSC-Addicted

  Points: 437

  More actions

  May 10, 2010 at 9:23 am

  #222361

  Hi,

  I'm executing following query from C# code.

  Set Showplan_xml on\rGo\r--Query--\rGo\rSet Showplan_xml off\rGo

  So that it will be executed as

  Set Showplan_xml on

  Go

  --Query--

  Go

  Set Showplan_xml off

  Go

  But I'm getting error that

  Incorrect Syntax near 'Go'

  The SET SHOWPLAN statements must be the only statements in the batch.

  If i execute the same query in sql server it is working fine.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738160

  More actions

  May 10, 2010 at 9:32 am

  #1165073

  What's in the query? Can you post it?

• HowardW

  One Orange Chip

  Points: 29109

  More actions

  May 10, 2010 at 9:41 am

  #1165080

  Go is not a T-SQL command, it's syntax used in Management Studio to signal the end of a batch. If you're submitting it from a .Net application, you have to submit the batches separately yourself.