how to use without using query parameter..

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'Test',

@recipients = 'xx@abc.com',

@subject = 'Work Order Count',

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

its executing properly but mail...

its using query but i need send csv file its stored in my disk

here not open this pages..pls provide how to use it..

how to use sp_send_cdosysmail format in sql server 2008..give me solution..

thks now its working... before that i used sql server 2000 now i migrate to sql2008 so i need send mail same format without change script and without create profile..pls...

thaks ii have configured but i check error log

SELECT * FROM msdb.dbo.sysmail_event_log

msg is

"The mail could not be sent to the recipients because of the mail server failure. (Sending...

job alert..when job is completed after that automaically send to mail..

sql server job alert..

thks for reply..one more small query

when i used sql upgrade advisor i couldn't find any error but when i compiled procedure that show show error..so i need how to...

any other than this tool..?

s exactly