pzn3xq wrote:
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE name LIKE '#FileSpaceStats%') BEGIN DROP TABLE #FileSpaceStats END
# means a temporary table and such tables are stored in the tempdb. So the above query looks for a temp table starting with FileSpaceStats and drops #FileSpaceStats in case it exists. Hope that helps. Regards, Syed Mehroz Alam
My Blog My Articles Computers are incredibly fast, accurate, and stupid; humans are incredibly slow, inaccurate and brilliant; together they are powerful beyond imagination. - Albert Einstein