need help how to send a email with query !!
-------------------------------------------
Send SMTP mail directly from any version of MS SQL Server.
-----------------------------
the Instructions is in this site http://www.thorpesoftware.com/
-----------
declare @query varchar(200)
exec master.dbo.xp_SMTPSendMail80
select @query = N'select * from sysusers',
'user@server.net',
'user@server.net',
'server.mail',
'help error'
------------
i get this error
-----------
Server: Msg 141, Level 15, State 1, Line 7
A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.
-------------------------------
thnks ilan