where is the Temp tables located in SQL server database?

Validating the user

Updated:  07/14/2014 11:07 AM
Author:  Shiju Mathews

Status:    Resolved.

  • Go to SSMS and connect to your server.
  • Expand Datatbases
  • Expand System Databases
  • Expand 'tempdb'
  • Expand 'Temporary Tables'
    Locate the table that you are searching.