Even after truncating temporary tables , still shows same size not get reduced even a MB

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

hi Eric, as i told previously i have truncated temporary tables. it also got much records. but after deletion still properties of the datafile of that database shows the same 2.03GB . not even single MB get reduced. what is problem. is data not then affects datafile. i think it wont be like that . what might be problem.

-- Anonymous, May 14, 2003



If those temporary tables were in tempdb, truncating them would have no effect on your "real" database.

Hope this helps,


-- Anonymous, May 17, 2003

Moderation questions? read the FAQ