Yes

sleeping means it's waiting for a command to get process.

It's not a mapped drive as I can't see it. I do have sys admin rights.

nite_eagle (12/5/2007)

---

To change it manually, double click on each access connection and click on the ... button. Browse to the new database location and clikc OK, OK.

Do you want to...

I now know what the package does. Deletes the table and copies the Access record to SQL server table.

New question.

The way Connection Properties access to this file. This...

Read article all about transactions and it helped me alot.

Recreated the on success lines and it worked charmingly.

SS2K5 to AS400.

I have scrolled and asked someone to look it up for me. It's no there.

I have that.

sqldba (10/18/2007)

---

from sql server 2005 every thing is Native SQL client & what you are looking for is it within Start---Admin tools---- ODBC Config. or are you trying to some...

Thank you,

Backup file saved my life.

Thank you guys!

Found out other jobs are blocking this job. Change the execution time for the blocking job and it solved my problem.

why replication is not a good choice ?

what is SMO?

i want copy 7 tables from prod to DEV. Have to refresh every week.

I want to...