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

  • November 22, 2010 at 4:55 am

    #1253662

    Randhir Singh (11/22/2010)

    Good question!!!

    I just want to add few lines here..

    1. sysobjects is a view not table

    And a deprecated one to boot. New code should use the new system views. In this case, sys.objects.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/