Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLSoaker
Posting Yak Master
169 Posts |
 Posted - 2008-12-15 : 11:42:32
|
| Hello,Am trying to use sp_send_dbmail using SQL 2005.DECLARE @body1 VARCHAR(1024) SET @body1 = 'SQL send mail test on this day:'+ CONVERT(VARCHAR, GETDATE()) EXEC msdb.dbo.sp_send_dbmail @recipients='me@me.com', @subject = 'SQL Test Mail', @body= @body1, --@execute_query_database = '', --@query = 'CustomerStatement_AgingBuckets @dataareaid = ''xxx'', @accountnum = ''100001''' @query = 'select top(100) accountnum from mydb.dbo.custtable' --@attach_query_result_as_file = 1 Simply trying to send a query result thru email!Getting this error msg:Could not allocate space for object 'dbo.sysmail_mailitems'.'sysmail_mailitems_id_MustBeUnique' in database 'msdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.Anyone have any idea as to how to solve?Thanks in advance.Regards. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 11:50:03
|
| http://www.banmanpro.com/support/filegroupfull.asp |
 |
|
|
SQLSoaker
Posting Yak Master
169 Posts |
Posted - 2008-12-15 : 12:13:22
|
| Thanks visakh16 for the quick reply.The database that is giving me the error is MSDB. Looks like it has nothing to do with my DB?!?How would this be a microsoft db problem? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 12:17:38
|
| http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=34887 |
|
|
|
|
|
|
msdb.dbo.sp_send_dbmail help!