SQL Handle

• nadersam

  SSCertifiable

  Points: 6542

  More actions

  October 8, 2010 at 4:08 pm

  #230214

  Hi All,

  Anyway to get sql text using sql_handle value in sql server 2005 but compatability level 80?

  Thanks

  Nader

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  October 8, 2010 at 10:42 pm

  #1234589

  You may make use of fn_get_sql function. More information here

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• nadersam

  SSCertifiable

  Points: 6542

  More actions

  October 9, 2010 at 2:11 am

  #1234596

  Thanks alot for your support , it was very helpfull.

  Regards

  Nader