Hi,

Any information will be helpful..

Thanks,

I managed to fix it by creating a DL in outlook and using that DL in the database mail. Not really sure, if microsoft has a limit on the number...

Books online states that shrinkdatabase cannot shrink smaller than its original size. So, how does SQL Server know the initial size / original size of the database without saving it...

Thanks a lot for detailed explanation

I also found the below lines from "http://support.microsoft.com/kb/315512"

•If you combine the autogrow and autoshrink options, you might create unnecessary overhead. Make sure that the thresholds that trigger the grow and...

The reason for shrinking the log is

"a drive could have log files of multiple databases. If, one log file has over grown due to a big transaction , the...

Thanks for the reply.. I would like to know why should we keep the master database in "master only recovery mode". What happens if we don't keep it in the...

Thanks for the Script. It is very useful. While scripting out the object level permissions, i think, the below line that has been highlighted (Underlined) should have been "QUOTENAME(SCHEMA_NAME(obj.schema_id))". Please...