question

Iain avatar image
Iain asked

SQL Server 2000 Message store

Hi Our SQL Server 2000 has stopped sending notifications and alerts. When I try and test sending to a listed operator, it returns the following error message: Error 22022 SQLServerAgent Error The message store has reached its maximum size.

Can anyone help with the following? Where is the message store, and how do I reduce\delete messages from it?

Thanks in advance

Iain

sqlsql-server-2000
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered

This suggests that the email account you are using (to send from) has reached it's maximum setting. The message is coming from Exchange.

Try opening this account in your email client and clearing out some messages? Or if there is not a lot of messages, get the storage limit raised.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.