Hello,

i have a question on this. Maybe you can help...

Following SQL works fine:

Select

*

from

Openquery(siebeldb

yes that sounds great - has someone an example of this?

regards

audi

Hi,

im using 2005 with the newest sp2. 😉

regards

andreas

Hello,

it doesnt work for me. Only existing records get updated. Maybe its an SP2 issue ? On this box we've installed the sp2... Is there the "right" behaviour on sp1...

i thought yukon has no workload gov anymore?

regards

andreas

hm yes... it would be more easy... all columns... no worry about ntext fields...

you have good expieriences with this approach...

my idea was to keep the db small... but...

or do you think it is better to make for each table in the app an audit table... there are about 200-250 in right now...

regards

andreas

hi,

but how can i do this when i only have to audit the edited columns... only at runtime i know them...

regards

andreas

i want to audit important tables... this trigger should audit the old and new value of each column that is changed...

regards

andreas

Hello,

i want to use it in a trigger...

----------ALTER Trigger tr_admin

-- list all columns that were changed

On ArtikelT

For Update

As

 SET NOCOUNT On

 declare @intCountColumn int, @n int, @tblname sysname

DECLARE @AlterWert nvarchar(100)

DECLARE @NeuerWert...

I've checked this withe the profiler. implicit transactions are off.

if they are set on for one connection this will affect only this connection, right?

@steve-2: yes, a whole...

Hello Markus,

I read in the BOL that implicit transactions are not standard. They have to be turned on and are only valid for one connection.

The Server rolled back the data...