>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'
If it's not broken, fix it until it is.
My Blog