http://sqlblog.com/blogs/linchi_shea/archive/tags/Temp+table/default.aspxTags: Temp tableenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/linchi_shea/archive/2010/11/17/linked-servers-a-case-for-global-temporary-tables.aspxWed, 17 Nov 2010 21:28:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:30694Linchi Shea20http://sqlblog.com/blogs/linchi_shea/comments/30694.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=30694I'm not a SQL Server historian, so I don't know exactly when the global temporary table was first introduced into SQL Server. The feature may have been around since the very genesis of SQL Server. But I know for sure that it has been there since I started...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2010/11/17/linked-servers-a-case-for-global-temporary-tables.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=30694" width="1" height="1">global temp tableLinked serverTemp tablehttp://sqlblog.com/blogs/linchi_shea/archive/2010/07/15/temp-table-name-resolution-or-maybe-not.aspxThu, 15 Jul 2010 21:33:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:27091Linchi Shea3http://sqlblog.com/blogs/linchi_shea/comments/27091.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=27091I was reading Michael Coles' post on Dynamic SQL and Late Binding , and it reminded me of an issue I struggled with a while back. The issue started out as a local temp table name resolution issue. But it was also a compilation time vs. run time issue,...(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2010/07/15/temp-table-name-resolution-or-maybe-not.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=27091" width="1" height="1">name resolutionTemp tabletempdb