Hi Wayne,

I've been looking into this and am happy to say that it should, MS have finally listened to the users and removed the dependance on outlook.  It's been a...

thats the very one I was looking for, was just about to post the link but now I don't have to

You should be ok with the standard uninstall method, however I've had to do a few full complete uninstalls on test systems to solve problems in the past.

I'll see if...

Wouldn't it be better to generate the temporary table inside the stored procedure? That way you just pass the parameters needed to generate it along with any other parameters you...

You could always BCP/DTS the data out of the suspect database into another one, it might not help very much with recreating indexes, triggers and the like but hopefully you've...

If you've got a fill factor set then this could increase the amount of io that SQL needs to do to retreive the data.

I tend to have ours set around...

got your PM but couldnt reach your email, sent the questions via PM instead

I tend to create one MDF file for each processor, and just the one LDF because it's written sequentially

rather than communicate via the forum can you send me your email address via PM.

I have a couple of questions and it would be easier to do it that way.

thats a bit of a monster

I'll take a look and see what I can do

you're welcome, glad I could help you out.

If I understand your question correctly you want to be able to agregate all of the monthly figures. Something like below?

select datepart(y, date) as the year, datepart(mm, date) as theMonth,...

Target memory is the amount of memory that SQL would like to use, if it matches the total server memory counter then SQL has all of the memory that it...

Hi there, I think you're getting a little confused as to what log shipping is actually used for, namely keeping a second standby copy of the database in case something goes...

I'm fairly sure this is a duplicate post that has already been answered