msdb sysmail_attachments_transfer - very large, but 0 records

Our SQL server 2005 has a system table in the MSDB database called
sysmail_attachments_transfer. The management console summary report
shows almost 5 GB of data for the table with 0 records.
Table Name # Records Reserved Data
Indexes Unused
dbo.sysmail_attachments 1533 6178008 KB 6174160 KB 8
KB 3840 KB
dbo.sysmail_attachments_transfer 0 4936816 KB 4935864 KB 8
KB 944 KB
This is puzzling. I would like to know more about this system table,
and to get back some of the space used, if possible. Does anyone know
anything about this? There doesn't seem to be any documentation
anywhere on it.
Rob Fisch
Kaz, Inc.
Hi
This looks like it holds the results of queries that are attached see
http://www.elsasoft.org/SUMMER.msdb/sp_dbospsenddbmail.htm but I have not
found much more than this.
What does sp_spaceused give for this table?
Although this information should be correct you may want to try DBCC
UPDATEUSAGE to see if anything changes.
John
"rfisch@.gmail.com" wrote:

> Our SQL server 2005 has a system table in the MSDB database called
> sysmail_attachments_transfer. The management console summary report
> shows almost 5 GB of data for the table with 0 records.
> Table Name # Records Reserved Data
> Indexes Unused
> ----
> dbo.sysmail_attachments 1533 6178008 KB 6174160 KB 8
> KB 3840 KB
> dbo.sysmail_attachments_transfer 0 4936816 KB 4935864 KB 8
> KB 944 KB
> This is puzzling. I would like to know more about this system table,
> and to get back some of the space used, if possible. Does anyone know
> anything about this? There doesn't seem to be any documentation
> anywhere on it.
> Rob Fisch
> Kaz, Inc.
>
|||Hi John,
sp_spaceused gave the same reading as the summary report.
DBCC UPDATEUSAGE didn't change anything to speak of.
Thanks for the link. It was interesting. There may be some clues in
there, but nothing jumps out at me.
Thanks for giving it a stab.
Rob
John Bell wrote:[vbcol=seagreen]
> Hi
> This looks like it holds the results of queries that are attached see
> http://www.elsasoft.org/SUMMER.msdb/sp_dbospsenddbmail.htm but I have not
> found much more than this.
> What does sp_spaceused give for this table?
> Although this information should be correct you may want to try DBCC
> UPDATEUSAGE to see if anything changes.
> John
>
> "rfisch@.gmail.com" wrote:
|||Hi
I am not sure what has caused this. Have you tried DBCC CHECKDB?
John
On Nov 4, 1:55 am, "Rob Fisch" <rfi...@.gmail.com> wrote:[vbcol=seagreen]
> Hi John,
> sp_spaceused gave the same reading as the summary report.
> DBCC UPDATEUSAGE didn't change anything to speak of.
> Thanks for the link. It was interesting. There may be some clues in
> there, but nothing jumps out at me.
> Thanks for giving it a stab.
> Rob
>
> John Bell wrote:
>
>
>
>
|||Well I guess the good news is that DBCC CHECKDB reports "CHECKDB found
0 allocation errors and 0 consistency errors ".
John Bell wrote:[vbcol=seagreen]
> Hi
> I am not sure what has caused this. Have you tried DBCC CHECKDB?
> John
> On Nov 4, 1:55 am, "Rob Fisch" <rfi...@.gmail.com> wrote:
|||Hi ROb
What version are you using (SELECT @.@.VERSION) ?
I guess you could try manually deleting from/truncating the table even
though it is reporting no rows.
"Rob Fisch" wrote:

> Well I guess the good news is that DBCC CHECKDB reports "CHECKDB found
> 0 allocation errors and 0 consistency errors ".
>
>
> John Bell wrote:
>