<div>
Both answers in the thread indicates that author had the problem with the permissions. 
</div>


<div>
I totally agree with dwkor. These poster get ideas from experts and come and say, &quot;I resolved my own problem&quot; when infact they did with experts help.<br />
<br />
In case, it was a permission issue which was sugested for him.
</div>


<div>
<div class="content wysiwyg-content">
This works perfect;<br />
<br />
exec msdb.dbo.sp_send_dbmail @profile_name = 'SQLMal'<br />
&nbsp; , @recipients = 'itmanager@xyz.com'<br />
&nbsp; , @subject = 'Consistency Checks of DEV'<br />
, @File_Attachments c:\ConsistencyChecks\Consi<wbr />stencyJobO<wbr />utput.txt'<wbr /><br />
<br />
But if I want to attach the file(like below) from remote location why does it not like, can anyone please let me know why it does not like remote location, I don’t want to create a network drive.<br />
<br />
@File_Attachments =‘\\dev\c$\ConsistencyChec<wbr />ks\Consist<wbr />encyJobOut<wbr />put.txt'<br />

</div>
</div>


This works perfect;

exec msdb.dbo.sp_send_dbmail @profile_name = 'SQLMal'
  , @recipients = 'itmanager@xyz.com'
  , @subject = 'Consistency Checks of DEV'
, @File_Attachments c:\ConsistencyChecks\ConsistencyJobOutput.txt'

But if I want to attach the file(like below) from remote location why does it not like, can anyone please let me know why it does not like remote location, I don’t want to create a network drive.

@File_Attachments =‘\\dev\c$\ConsistencyChecks\ConsistencyJobOutput.txt'


Both answers in the thread indicates that author had the problem with the permissions. 

I totally agree with dwkor. These poster get ideas from experts and come and say, &quot;I resolved my own problem&quot; when infact they did with experts help.

In case, it was a permission issue which was sugested for him.

sql mail attach-network -file

This works perfect;

exec msdb.dbo.sp_send_dbmail @profile_name = &#39;SQLMal&#39;
  , @recipients = &#39;itmanager@xyz.com&#39;
  , @subject = &#39;Consistency Checks of DEV&#39;
, @File_Attachments c:\ConsistencyChecks\ConsistencyJobOutput.txt&#39;

But if I want to attach the file(like below) from remote location why does it not like, can anyone please let me know why it does not like remote location, I don’t want to create a network drive.

@File_Attachments =‘\\dev\c$\ConsistencyChecks\ConsistencyJobOutput.txt&#39;


Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Network Operations includes asset management, help-desk supervision, security and user policies, infrastructure administration and anything else that affects the operation of your network. Discussions will include those of best practices in platforms, configurations, performance, security and accounting.