I'll get you to agree with me someday soon, I'd guess .

What do you mean?

He told you not to reduce it because that's pointless on the long run. How much free space do you have on that file (%)?

Ya, those questions are simple enough where you don't really lose time if you're wrong... and you can't be all that wrong anyways .

Don't put it like that, and you're welcomed .

Ya wasn't too sure about that myself... but I'm wondering why someone would need that info... I guess we'll know later on.

Same question.. but I couldn't find a work around that didn't use the system tables directly :

create table #temp (name varchar(20) not null)

Select OBJECT_ID('tempdb.dbo.#temp')

Select name from tempdb.dbo.SysColumns where id...

Don't feel bad Crish, I missed a lot of them, but I'm actually more of a developping guy so I never worked with the server itself so that's almost not...

Don't worry about it... it's gonna happen again .

It's not like I'm trying to type slower with each passing day or anything

HTH.

Not sure but shouldn't it be :

SELECT DATEPART(YEAR, SaleDate) SaleYear, Product, SUM(SaleQty)/12[.0] AvgSalesPerMonth

FROM

orderdetail

GROUP BY DATEPART(YEAR, SaleDate), Product

as the /12 actually takes care of the average

I know that... just wanted to be sure that he knew that too. .

Dito... you don't need dynamic sql to do that.

they should... try just swapping the files.

Close the server and rename its msdb files to msdbold.mdf... then copy the old db's file and restart the server. Another user did...

HTH.