Does anybody know if there is an Equivalent of the following in SQL 2000? This code works in 2008 but returns invalid object when trying to run it in SQL 2000. The purpose is to get all the field names in my Temp Table which is #MyBedsByDate.

SELECT Name 
FROM tempdb.sys.columns where object_id =object_id('tempdb..#MyBedsByDate') 

Thanks in advance

Kirk