Even after truncating temporary tables , still shows same size not get reduced even a MBgreenspun.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