Kevin

I have approached the Senior DBA to try to get permission to do this, but this company is funny.

Thanks for your input, I will try again

David

Gregg

Thanks I will try it

David

I have narrowed the problem down to a login problem.

Say I login with username 'smith' on the home and remote machine.

They have different passwords. This is accomplished through different...

Gregg

Thank you for your interest. I have a SSIS Job with six steps. The first five steps run stored procedures to truncate tables 1 to 5. Step...

D.

I think you are being brave, but the most important part of this is planning. The second is to attempt to get the datbase across as is.

Do not try...

Gail

Thank you very much for your comments. you are preaching to the converted.

This however is the very start of the development system and I only have 10 GB on...

Tommy

Thank you very much. That was exactly what I was looking for

Regards

David

Hi Vidyha

I have solved it. What happened was that I created a database with an initial size of 3mb. I imported a lot of data and increased its'...

The major Pro for using Linked Tables is the reduction in the amount of effort needed. The use of Passthru queries does require the dba to give Read, Update...