pls i need help friends..

thanks yar.. without administrator rights possiable to send mail in windows authendication sql server instance...?

Still having problem..attach mail only not going how to check..

service type is SMTP,enable_ssl is 0 otherwise default

windows authendication

how to check SMPT authendication..?

i have used this format.. mailserver ip is correct..but without attaching work..

EXEC sp_send_dbmail @profile_name='Test',

@recipients='ss@ss.com',

@subject='Test message',

@body='sp_send_dbmail test',

@file_attachments='c:\test\test.csv'

i try alot but attach mail not sent..when i execute that script mail in queue only but i did't receive..

ya without attachemnt working and file size is below 10kb.. when i send run attachemnt script mail in queue but not get mail...

ok thanks friend i have another doubt i store csv file in my sql server how to send attached mail.. i have use this script that time i got mail...

i give owner name is domain user id job created but i got warning..how to cleare this warning..?

Warning: Non-existent step referenced by @on_fail_step_id.

Warning: Non-existent step referenced by @on_fail_step_id.

Warning: Non-existent step...

i login in windows authendication can i give domain user name..?

when i run the script i got this error...?

Msg 515, Level 16, State 2, Procedure sp_add_job, Line 137

Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not...

which database i want to run the script..msdb or master..?

ya thaks working