first question is

do employee for example BBB should have access to "XYZ" and "PQR"?

First check permission on store where you getting file,

if you have permission try put N before files

@file_attachments = N'\\waccounting\ffwin\images\vendor\ap invoice\13085316.TIF;\\waccounting\ffwin\images\vendor\ap invoice\13085317.TIF;\\waccounting\ffwin\images\vendor\ap invoice\13085320.TIF;\\waccounting\ffwin\images\vendor\ap invoice\13085327.TIF;\\waccounting\ffwin\images\vendor\ap invoice\13085338.TIF;\\waccounting\ffwin\images\vendor\ap invoice\13085339.TIF;\\waccounting\ffwin\images\vendor\ap invoice\13085341.TIF;\\waccounting\ffwin\images\vendor\ap invoice\13085344.TIF;\\waccounting\ffwin\images\vendor\ap invoice\13085347.TIF;\\waccounting\ffwin\images\vendor\ap invoice\13085352.TIF;\\waccounting\ffwin\images\vendor\ap...

What operating system you have installed on remote machines?

on server BBB

I have the same problem and i solve that on this way

go to Component Services screen (Start -> Program -> Administrative Tools -> Component Services)

Expand Computers

Expand Distributed Transaction Coordinator

Right Click...

Sean Lange (10/7/2013)

---

SrcName (10/7/2013)

---

you can make this on this way

alter procedure w AS

exec('ALTER TABLE t ADD x char(1)')

exec('UPDATE t set x = 1')

But you can run only once. next time...

you can make this on this way

alter procedure w AS

exec('ALTER TABLE t ADD x char(1)')

exec('UPDATE t set x = 1')

But you can run only once. next time will be error....

view your connections String carefully

read some example from this site http://www.connectionstrings.com/sql-server-native-client-10-0-oledb-provider/

best would be to write on some vb forums

one of many ways:

if isnull(object_id('result'), 0 ) <> 0

drop table result

create table result ( state varchar(2), studentId varchar, marks varchar )

declare @db varchar(500)

DECLARE @index INT =0

DECLARE @N...

if the logic is like this then you may use RIGHT (not in where becouse there is performance problem)

you can try on this way:

select * from TABLE1 t join

( select...

parulprabu (10/3/2013)

---

SrcName (10/3/2013)

---

create table #temp

(

spid smallint ,

ecid smallint , ...

Sean Lange (10/3/2013)

---

???

I am curious how...

if you define constraint then you don't have situation for update,

because there will be no rows with impaired restriction, unless you disable constraint.

create table #temp

(

spid smallint ,

ecid smallint , ...

can you give us more detail about this problem.

sql error log, sql server entries from event viewer

that help many show when you have problem with using bcp.

Do you have privilege to save file on location where you want to save?

Do you try to add user name...