Hi guys,
A client of ours has almost no available space on the C:\ drive of the server. All SAP databases are on another partition. It has been found that the database MSDB in SQL is over 7 GB. I found this query and ran it on the database:
select sum(reserved)/128 as "Size in MB", object_name(id) as "Object Name"
from sysindexes
where indid in (0, 1, 255)
group by id
order by 1 desc
It turns out that there is a table called "queue_Messages_551673013" that is over 7GB in size. Is there anything that can be done about this?
Thanks,
Costas