Hi All

Thanks a lot. I will now just check the same.

Hi Phillip

Thanx,

My server can not be the same from where I am running my procedure since it is being run from different location with separate SQL Server login.

What could be...

Hi again,

Thanx Phillip

Yes..! I am using a SQL Server login.

Can u guide me how can I use Database Mail.

Thanks in advance

Hi Mohammed / Kenneth

My query is something like this which sends the output to .txt instead I want it in .xls or .csv

CREATE procedure mail @v_docno as char(10)

AS

declare @rec varchar(50)

declare...

Hi Kenneth

Thanks for the same.

My xp_sendmail generates the .TXT file by default using query output. I want redirect that output to either .xls or .csv instead of .txt. How do...