Thank you !

Juanita  

HI THANKS A BUNCH !! i'll do that !

Okay. Thanks again for the important info on the security patch. 

Juanita

Okay, Thank you so much. I'm going to download it now. Also, would you happen to know if  the error at the end of my sqlsp.log is the REBOOT MESSAGE?...

HI. is this patch for service pack 3A also?

Thanks,

juanita

HI..

Got it, this helps alot. Thanks for you input!

Juanita

HI Robert,

Thanks for the reply. I just read on dbcc dbreindex. how does that differ from dbcc indexdefrag? and is one better than the other? i do see that the...

Thanks a bunch. I did the install and it went fine. But I'm glad you mentioned about the other services. I will make sure to turn those off in our production...

Thanks so much to everybody that replied. I think I got it now.  Sure helps to get first hand help in addition to BOL.

A happy camper,

Juanita

Now that I've got my log files down in size by doing the backup log <dbname> truncate only and then the shrink file command, should i THEN perform a full...

Thanks a bunch. works like a charm.. I wasn't doing the truncate only and this was holding me up.

Juanita

Thanks so much. I got it to work !!

Juanita

Thanks so much. That's what I was hoping.

Juanita

THANK YOU SO MUCH... You just confirmed my initial feelings about giving query analzyer to our programmers. but it was made to sound i was ridiculous to not allow them...

HI Dana,

There default database is their user database and master still displays in QA. any suggestions. now i didn't remove the guest userid either.