Thanks Nic,

Totally forgot synonyms, still got my 2000 hat on. Makes logical sense.

Paul

Hi

I'm trying to use partitioning to switch data in and out of a partition on an hourly basis. I have a large amount of data that I want to...

SQL Server 2000 SP4

Since writing I believe I now know when the process locks.

If I have 2 STP that use a openrowset query, similar to above, to the same Oracle...