InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:59:01 GMT20http://www.sqlservercentral.com/Forums/Topic1416224-149-1.aspxplease don't cross post[url]http://www.sqlservercentral.com/Forums/Topic1416223-392-1.aspx[/url]Tue, 05 Feb 2013 23:19:51 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1416224-149-1.aspxmy queryUSE [AP_ECC]GO/****** Object: StoredProcedure [dbo].[ap_ecc_Mail_for_statuslog] Script Date: 02/06/2013 11:03:01 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER procedure [dbo].[ap_ecc_Mail_for_statuslog] asEXEC msdb.dbo.sp_send_dbmail@recipients=N'internal@zeroone.com',@body='Hi Team, Please find attached the status log for today.Please check the status .Regards,Reporting team',@subject ='Status Log for Today',@profile_name ='Status HDS A',@query ='SELECT [TableName] ,[DateLastRun] ,[StartTimeStamp] ,[EndTimeStamp] ,[StatusLastRun] FROM [ICMRPTSVR].[ICMRPTDB].[dbo].[icmrptdb_statuslog]',@attach_query_result_as_file = 1,@query_attachment_filename ='Status_Log.txt' my query is attaching txt file i want it as excel typeTue, 05 Feb 2013 21:23:46 GMTsandosh.star