Done :)...

These days, I am spending some time with Service Broker, testing various features exposed by SB. Many times, I am finding errors (due to my bad code) which results in dialog-conversations that are not closed, messages that are not processed etc. So, bef...

You saved my life . We had thousands of poison messages in many database after a maintenance and cleaning it up one by one may take years. Thanks Nelson www.PracticalSqlDba.com...

Hi Once you set this on history page , rest it will take care . It will automatlcally delete the history . You do not have to maintain a seperate job or maintenance plan Thanks Nelson www.PracticalSqlDba.com...

Hi This can be easily done from the the History page of SQL agent properties. Yes internal it use these procedure. Thanks Nelson www.PracticalSqlDba.com...