dakshinamurthy (2/26/2008)
Can i uncheck the check box of auto shrink is it okay to do that.
Absolutely. Uncheck it now. Autoshrink should never be enabled on a production server. See here for why - Autoshrink Turn It OFF
Is the distribution db set to auto grow?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability