sp_bindcache. is there an equivalent in sql 2005 ?

• Ian_McCann

  SSCertifiable

  Points: 5163

  More actions

  January 8, 2009 at 5:33 am

  #126343

  is there an equivalent to sybase's sp_bindcache in MSSQL 2005 ?

  Something along the lines of the MDX function CACHE() would work well, but I must call this from a regular TSQL script.

  Thanks in advance

• Ian_McCann

  SSCertifiable

  Points: 5163

  More actions

  January 8, 2009 at 6:41 am

  #923267

  OK I have found DBCC PINTABLE

  and read with great interest the caution staement on BOL.

  Does anyone have any advise on using this functionality

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  January 8, 2009 at 6:50 am

  #923276

  DBCC PINTABLE actually has no effect in SQL 2005.

  It's one of the discontinued commands in 2005.

  [font="Verdana"]Markus Bohse[/font]