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 |
|
Dani-hoochie
Starting Member
1 Post |
 Posted - 2004-06-23 : 06:55:33
|
| When I use the following bit of code the email is sent with a blank message. If I change the code to @message='test' it is fine. Why is this.declare @mymessage varchar(100)set @mymessage='test'exec master.dbo.xp_sendmail @recipients='myemail@test.co.uk', @message=@mymessage, @subject= 'Adverts in Queue' |
|
|
|
|
|
xp_sendmail with variables