OK I tried to setup on both the server in same domain, still it gives me same error.

Anybody has tried to store perfmon data into remote SQL server using odbc...

Thank you RBarryYoung

No, there is no other sql instance, only default instance

Another possibility, you do not have permission to use mail profile?

according to http://msdn.microsoft.com/en-us/library/ms190307.aspx

Execute permissions for sp_send_dbmail default to all members of the DatabaseMailUser database role in the msdb database. However,...

Can you run following under msdb and see if you find DENY on sp_send_dbmail and

GranteeName is not the user or any associates role?

If you have GRANT and DENY, DENY...

You are right, but this query might be just an...

Probably you want to reduce IO cost.

Following may help if you have enough sql memory available. if not, this may dump the intermediate resultset in tempdb and eventually more costly...

Data (or statistics) can be the issue some time

http://blogs.msdn.com/b/psssql/archive/2009/03/18/be-aware-of-parallel-index-creation-performance-issues.aspx

Can you try changing provider from SQLOLEDB to SQLNCLI in connection string?

Sorry I didnot understand your question.

If you want to send outcome (success or...

select Name,Gender

from (

SELECT row_number() over(order by Name) ID,name,Gender FROM #tmp where Gender='M'

union all

SELECT row_number() over(order by Name)+0.5 ID,name,Gender FROM #tmp where Gender='F'

) a

order by ID

First you need to setup mail profile (check following post) and use that profile in msdb.dbo.sp_send_dbmail procedure

http://www.sqlservercentral.com/blogs/databaseexpertisecom/2010/05/12/database-mail-set-up-in-sql-server-2008/

varchar(max) allows upto 2GB size of data, so that should not be the issue.

I suspect, your ASP application is using old sql driver to connect sql server.

if you have not...

I think "Total server memory(KB)" is the size of buffer pool and "physical_memory_in_use_kb" is total physical memory used by sql server

Did you try giving permission to [DomainName\MachineName$] on AS400?

This is not a good practice but I think this should work

You need to grant permission only to SQL service account on folder containing text file for BCP