Posted by dhek on 11/04/07 20:02

>>> Why not add such a column with a timestamp then?
>>
>> Yes, I'd love to - but its not just up to me, since I don't have
>> ownership of the database.
>
> I'm confused then. If you don't have ownership of the DB, how can you
> expect to set transaction levels and locking?

I cannot modify the configuration of the database - this also includes
tables and their design. I can however change my statements all I want and
for instance do

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO

BEGIN TRANSACTION trans1
SELECT ...
FROM ...
WITH (TABLOCK, HOLDLOCK, UPDLOCK)

UPDATE ...
SET ...
WHERE ...
COMMIT TRANSACTION trans1

which affects transactions and locking in the database.

>>
>> Well, I'm not sure what the possibilities are really with regards to
>> replication from SQL server. I doubt that it is usefull in my case, since
>> I pull data from an SAP system.
>
> Then I'm doubly confused.

Now me too:-)

[Back to original message]