2

Can anyone please tell me the name of Master table used by sqlserver 2008 to store dbmail information?

I tried to truncate "sysmail_sentitems" table but it gives me foreign key constraint violation error. Please reply if anyone knows.

Charlieface
  • 52,284
  • 6
  • 19
  • 43
priya patel
  • 45
  • 1
  • 5

1 Answers1

1

You are trying to truncate sysmail_sentitems which is a view, I doubt that possible.

Master table used by sqlserver 2008 to store dbmail information is msdb.dbo.sysmail_mailitems.

I navigate through SP_Helptext sysmail_sentitems which give another view sysmail_allitems. Using SP_Helptext sysmail_allitems gives me a table sysmail_mailitems.

I think sysmail_mailitems is the table which you need.

Pranav Singh
  • 17,079
  • 30
  • 77
  • 104