Naomi,

Thank you, here is what I ended up using.

select c.name from tempdb..sysobjects o inner
join tempdb..syscolumns  c on o.id=c.id where o.name like '#MyBedsByDate%'

Kirk

>>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
>
>Check syscolumns instead of sys.columns
>
>Also, Information_Schema.Columns view should work in SQL 2000 as well.
>

>SELECT Column_Name as Name from TempDb.Information_Schema.Columns
>WHERE Table_Name = '#MyBedsByDate'