Yes..NTFS and share perms are correct - well, wide open. The errors show NTAuthority\AnonymousLogin..hmm.. the database engine and agent are running under the service account.. Anything else?

This is excellent.. I'll tweak it as needed. Thanks so much.

Rich

I think the biggest hit performance-wise is with large/long transactions (index rebuilds etc) If the target can't keep up with the workload, thats what the REDO queue is for.....

I had our Inf team take a look and he confirmed a loss of connection with the DC at the time the the Authentication error occurred and we confirmed that...

I believe SP2 includes Login Triggers that will fire on login

Colin, I get they are different, which is why they are used in different situations.. I was looking for the reason you would recommend using /PAE+AWE with only...

Colin.. can you clear something up for me?

if you have only 4GB of Ram (which can be addresses natively with 32bit OS), why would you use the /PAE switch? ...

Yes.. on a 32 bit system you need the /PAE to address more than 4GB.. You would use the /3GB switch in the boot.ini to allow the applications to...

Hi.. Did you try connecting through intergration services in SSMS? Under registered servers click on the "intergration" button (the one on the right) and then connect to your server.....

There are a few ways to do this.. you could open up SSMS(managment studio) and right click on the DB in question and go to properties.. you can then select...

Thanks all.. I should have taken a closer look at the versions (both Enterprise) however the dev box was missing a hotfix. After I installed it, the plans matched...

You can run sp_help_jobhistory (MSDB) and it will return runtimes/jobnames etc if you really want to get specific you can open up the proc and see where it pulls its...

hmm, I set up couple tables with source and destination as what you described and did not have an error converting.. Perhaps there is something flaky with your...

I would use a dataflow task and then insert a data conversion task.. that will handle the conversion for you..

If you go into the log viewer inside SSMS you can select "load Log" and browse to the location of the DT logs and open them up that way...