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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 email table

Author  Topic 

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 2007-01-15 : 21:12:46
im using this type of command to send an email:

EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Mina',
@recipients = 'bla@bla.com',
@body = 'i want the table to be here??',
@subject = 'hi';

but how do i get it to email me a table?? not just a variable

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2007-01-15 : 21:27:44
You should consult the SQL Server 2005 Books Online sp_send_dbmail topic to see examples of how to do this:
http://msdn2.microsoft.com/en-us/library/ms190307.aspx





CODO ERGO SUM
Go to Top of Page

rnbguy
Constraint Violating Yak Guru

293 Posts

Posted - 2007-01-15 : 21:39:42
yep figured it and forgot to update post thanx :)
Go to Top of Page
   

- Advertisement -