dynamically parse t-sql string without executing it

• dan-309633

  Grasshopper

  Points: 23

  More actions

  March 12, 2006 at 11:38 pm

  #168013

  hey,

  i'm passing a dynamically entered string from the front-end web-server to sql server and need a way to parse the string the way sql server query analyzer does when f6 is pressed.

  this way, the parser engine does not execute the query, and does not generate an error, but rather gracefuly returns the result of the parse attempt.

  furthermore, once that issue is addressed, i need a way to show the execution tree of a query without actually running it. if thats possible, i dont know?

  i know sql server 2005 has much better support for displaying the query execution tree in xml format, but i'm currently using 2000 - for now, and want to know what my options are.

  any help would be much appreciated. thanks.

• Jo Pattyn

  SSC-Dedicated

  Points: 32520

  More actions

  March 13, 2006 at 8:27 am

  #626268

  You have a few options:

  SET PARSEONLY (connection setting)

  SET NOEXEC (connection setting)

  SET SHOWPLAN_TEXT (connection setting)

  SET SHOWPLAN_ALL (connection setting)

  What they do is described in the books online (BOL)