Thanks,

That's what I thought to do.

Is that possible to provide the update query will give me the desired results ?

Hi

This link is not working. Could you please send me this script in gmail please.

nitinuniyal@gmail.com

Thanks

NU

SQLCLR is worth trying..Utility.FileSearchInternal and Utility.FileRename will do the trick... lemme try this...

many thanks for the suggestions...

Hi Sean,

We are using nolock only in select statement as recommended by our Application vendor, Our OLTP is too high and any lock even for milisecond can cause major issues....

Thanks Sean,

I got my answer now mt query is running and export is also working fine.

I was just missing the double quotes in inner query.

Regards

NU

Thanks ...

They are doing the normal backup not compressed...:( We are doing the weekly full and daily incremental..

and i do agree its a problem with network, but we need to...

Thanks Jeff,

We are using the network to take the backup's, As we are using VM's so i am not sure how we can use dedicated HBA's. After my discussion with...

Ace !!!

it worked... thanks for the support...

Working code :-

declare @attach nvarchar(max)

set @attach = 'C:\Files\Reports\Call_Center_Audit_Reports\CallCenter_Audit_Report_'+CONVERT(NVARCHAR,GETDATE(),112)+'.xls'

EXEC sp_send_dbmail

@profile_name='NASA01_mail',

@recipients='gfgfgf@eee.com.sa',

@subject='callcenter Audit Report',

@body='report',

@file_attachments= @attach

Thanks !!! but Same error :exclamation:

Msg 22051, Level 16, State 1, Line 0

Attachment file "C:\Files\Reports\Call_Center_Audit_Reports\\" + "Audit_Report_" + REPLACE(SUBSTRING CONVERT(NVARCHAR,GETDATE(),112), 1, 10), "-","") + ".xls" is invalid.

Hi Jeff, One last help if its possible for you,

Could you please let me know how we can get the below SP result in HTML.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

--...

Hi Jeff,

INDEED a solution and i think this will help to peel all patatos and serve them as fries 😀 .

Thanks again for the solution and now i...

Thanks Jeff for looking into my query, I have attached the xlsx file which i need as a attachment in my mail to users.

All i want to do is to...

Thanks Jef for looking into my query, I have attached the xlsx file for your refrence.

Thanks Mate,

I think i will try SSIS package, of not then old good way of csv:-D

[font="Tahoma"]Thanks for the Reply..

But what i want is to mail the results in Excel format, if I only define the SP in query then it will only give me the...