So you are right - the agent is the correct task to do this. In SQL Express I do not have an agent - but the service broker is available....

because of duration... I thought this is a big brake...

thank you all for your replies!!!!

I want to disable updating index for one batch, the index should be online for other batches.

Example:

<BEGIN TRANSACTION>

<do not update index>

<CURSOR>

<UPDATE TABLE>

<RENEW INDEX>

<COMMIT TRANSACTION>

I'm sorry about my short description.

Example: There is an table tmp.Stats (GUID,Name,...,dtCreated) with an INDEX IX_tmp_Stats_dtCreated.

When I know do multiple inserts I assume that the index will be updated...

...doesn't work...

I try to explain again:

I want to source some statistics-tables out from one sql server to another sql server. I wrote same triggers to do this. Simultaneous I...

Here is my own solution:

You can define the execution context for the trigger using WITH EXECUTE AS:

ALTER TRIGGER <triggername> ON <tablename> WITH EXECUTE AS OWNER AFTER INSERT, UPDATE...

If you do...

just want to specify my question:

I have two servers in different domains. I want to create on machine A a linkedserver reference to machine B. On both machines "sql server...

Hey Lowell,

thank your for your reply. It seems to work. Indeed it shows me "CREATE STORED PROCEDURE" when I'm running the Procedure via EXEC, but it's ok to identify the...