I am moving some stored procedures from a database in SQL Server 2008 R2 to an identical database in SQL Server 2008 (not R2). One of them makes use of temporary tables. While the create script generated from the R2 database executed fine, the temporary tables and fields display as being invalid object names.I am moving some stored procedures from a datab