R2 just came out last month and this article from June 2009 and it doesn't say anything for R2

I know there is R2 package came out for express,but I don't have that I have 4G express2008 and I can't understand, how come my tem db is over 5G...

I am littele confused,but at this time I have 5474.63 MB for temp if I re start sql server instanse, I thought temp db re creates again and size would...

How is it posible anyway, I though you can have only 4G in sql express

My temp db size 5474.63 mb and available is 5472.82 MB, how can I make it smaller

temp db is already in simple

Thank you

I can't get to the server, is there sql statment I can to check? Thank you

Thank you for this information, but i STILL WOULD LIKE TO KNOW how to reduce Data, when I change and save it goes back

This table captures eror logs, which we don't need to keep, I keep it for 1 month.The problem is we make a back up of this db 2 times a...

Why his table is taking so much space?

I am deleting records from this table and should have about 200000 rows left, should db get smaller?

I can go to the prpertes now, that was something else

Is this supposte to give performance issues? I want to go to the properties of he db after I ran that code and it is timing out on me?

sumsumsumsumsum

5744.140996.3464747.79960.7534687.050

Object NameTypeRowsTotal(MB)-Unused(MB)==Used(MB)=Index(MB)+Data(MB)

dbo.AddressU 50.016-0.000==0.016=0.008+0.008

dbo.AffiliatesU 00.000-0.000==0.000=0.000+0.000

dbo.AnnouncementsU 20.070-0.000==0.070=0.039+0.031

dbo.AnonymousUsersU 00.000-0.000==0.000=0.000+0.000

dbo.aspnet_ApplicationsU 10.063-0.000==0.063=0.055+0.008

dbo.aspnet_MembershipU 240.047-0.000==0.047=0.031+0.016

dbo.aspnet_ProfileU 00.000-0.000==0.000=0.000+0.000

dbo.aspnet_RolesU 00.000-0.000==0.000=0.000+0.000

dbo.aspnet_SchemaVersionsU 40.016-0.000==0.016=0.008+0.008

dbo.aspnet_UsersU 240.047-0.000==0.047=0.039+0.008

dbo.aspnet_UsersInRolesU 00.000-0.000==0.000=0.000+0.000

dbo.AssembliesU 30.016-0.000==0.016=0.008+0.008

dbo.AuthenticationU 30.016-0.000==0.016=0.008+0.008

dbo.BannersU 00.000-0.000==0.000=0.000+0.000

dbo.Blog_BlogsU 20.047-0.000==0.047=0.039+0.008

dbo.Blog_CommentsU 00.039-0.000==0.039=0.023+0.016

dbo.Blog_EntriesU 40.125-0.047==0.078=0.039+0.039

dbo.Blog_MetaWeblogDataU 10.016-0.000==0.016=0.008+0.008

dbo.Blog_SettingsU 20.016-0.000==0.016=0.008+0.008

dbo.CategoriesU 280.016-0.000==0.016=0.008+0.008

dbo.ClassificationU 00.000-0.000==0.000=0.000+0.000

dbo.CoremetricsSettingsU 1570.063-0.000==0.063=0.008+0.055

dbo.Dashboard_ControlsU 60.016-0.000==0.016=0.008+0.008

dbo.DefaultSearchResultsU 110.023-0.000==0.023=0.008+0.016

dbo.DesktopModulesU 710.109-0.039==0.070=0.047+0.023

dbo.DocumentsU 10.047-0.000==0.047=0.039+0.008

dbo.DocumentsSettingsU 10.016-0.000==0.016=0.008+0.008

dbo.EventLogU 5616815726.102-994.203==4731.898=56.813+4675.086

dbo.EventLogConfigU...