Here is the command and output.

FYI: 'dbo.EXTGEN_InitSessionContextSp' is getting called from Rpt_JobTransactionsSp

bcp "exec PHIL_App..Rpt_JobTransactionsSp 'SRMQDIC','ROD','B','HNS','0','B',

null,null,null,null,'000','9999','1/1/2013','3/17/2013',null,null,null,null,null

,null,null,null,'T',null,null,'1','0','1033'" Queryout "c:\temp\query.txt" -T

-c -t^| -Sphlsqlsl01

SQLState = 37000, NativeError = 2812

Error = [Microsoft][SQL...

Yes In the code i am appending the Servername but i get same result with or without the ServerName.

I am running the code from the SQL Server Management Studio.

Do i need to specify the Server name , user name and password ?

SELECT top 10 * FROM OPENDATASOURCE( 'SQLOLEDB', 'Data Source=Server1;User ID=user1;Password=password').orders.dbo.folder

this statement returned error

OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked...

exec('exec OPENDATASOURCE(''sqloledb'',''Data Source=sqlsrv1; User ID=user1;Password=Pwd1'').Orders.dbo.testreport''' + @parameter1 + ''','+@parameter2+'' )

Above statement gives me error

Incorrect syntax near ','.

Actually i want to read from a text file . \\server1\temp\EmailBody.txt into a variable

Thanks for the reply.

Another Quick Question. My Email body is very long.

Ideally i would like to store the Body in a text file and read the text file into a...

Thanks for the reply.

Another Quick Question. My Email body is very long.

Ideally i would like to store the Body in a text file and read the text file into a...

Thanks for the reply.

Another Quick Question. My Email body is very long.

Ideally i would like to store the Body in a text file and read the text file into a...

Thanks for the reply.

Another Quick Question. My Email body is very long.

Ideally i would like to store the Body in a text file and read the text file into a...

Thanks for the reply.

Another Quick Question. My Email body is very long.

Ideally i would like to store the Body in a text file and read the text file into a...

Yes it there are applications running which access these tables.

Here is the information from using the DBCC SHOWCONTIG command

DBCC SHOWCONTIG scanning 'job' table...

Table: 'job' (2142630676); index ID: 1, database ID: 64

TABLE level scan performed.

- Pages Scanned................................: 7391

- Extents Scanned..............................:...

This works great

.

select stuff((

select ' ' + ReportNotesView.note as [text()]

from ReportNotesView WHERE RefRowPointer = '06F7539D-44B3-4438-BE89-6FB1F45B569E'

for xml path(''), type

).value('.','NTEXT'),...

Is the outer proc Rpt_AccountsReceivableAgingSp the one returning the resultset? Or is it one of the called procs that is actually returning the resultset?

The Procedure Rpt_AccountsReceivableAgingSp is where the result...