Home Forums Article Discussions Article Discussions by Author Discuss content posted by VM temp table in sysobjects RE: temp table in sysobjects

  • November 24, 2010 at 1:51 am

    #1254931

    archana.singh 38798 (11/23/2010)

    This will surely work :

    select * from sysobjects where name like '#testvm%'

    No, because it will also return tables called '#testvm_something' etc. as was explained earlier

    Nigel
    How to post questions