I guess u need to have share permission on that foilder , and if not then use net use and create a script using bcp command prompt utility and put...

quote:

---

Why are you using two different tools that effectively accomplish the same thing? If there is already transactional replication going, why...

Can any1 tell me what will be the field and row deliminator for a Visual Fox pro "dbf" file. So i can just do the Bulk Insert facility (as u...

quote:

---

If coming from a client app then have the app do a replace of the ' with '' (two single quotes).

VB

REPLACE(variablename,"'", "''")

C++

cStringVar.Replace("'","''")

Another...

Yes sir u r right, but theoretically speaking the query optimizer should scan with the nonclustered index bcoz its in the where clause.

There r somewhere around 40000 records in that...

Check out on ur binn folder of the installation path whether the sqlagent(EXE) is there in the folder, this might help u.

I think thst the problem.

In ur parent table where the DTS is occuring write a trigger on insert.

In that chk wheter the child table has that record in it. If it is there then...