DBA or developer.

I have it where it pulls parameter by state and now I want to have a parameter ZipCode. Do I need to do a shared dataset because if I just...

Thanks I keep putting DATEADD(day, +5, GETDATE()) not just the 5

did not notice that.

I am not sending a file just what was inserted into the table.

Changing the @body nvarchar(255) now it works

Thanks for both of yawl's help

I got it fixed changes sql server to local system and now email works.

Thanks you all for your help.

sql server is network service and server agent is local system

service broker is enabled

I think so i will check when i get back to work tomorrow

I ran both of these codes and for the top one nothing showed up in the results and for the

EXEC msdb.dbo.sysmail_stop_sp

EXEC msdb.dbo.sysmail_start_sp

SELECT * FROM msdb.dbo.sysmail_allitems;

it shows everything...

How is that done

ok thanks changing them to a varchar works now.

yes they are text

I get this error Operand data type text is invalid for add operator

the PhoneNumber is in the Names table and the sms is in the Carriers table

I have phonenumber and sms set as Text. The PhoneNumber is in the Names table and SMS is in the Carriers table.