you ONLY need a delete trigger to fire...

assume:

ID is pk or unique,

(PRODUCTIONNO, STARTTIME) also a unique key.

trigger as follows:

CREATE TRIGGER table_name_dt

ON table_name

AFTER DELETE

AS

BEGIN

 declare @d_starttime datetime

          , @d_endtime...

why you don't you output results from each server into a file and then append into your table?

Hans, you are joining 2 tables from 2 different dbms you have to used linked server. I don't think there is another way.

one way you can get around....

if the sybase...

I agree, pk should be clustered but should index be created on the same column(s) as pk? if yes why?

how do you copy data from one server to another?

I assume the destination table has identity set on ID column.

Couple ways to get around - though maybe not the best...

you forgot begin and end block

Raj, did your db changed owner?

one way is,

loop thru all your databases in the instance

run this:

select 'sp_changeobjectowner "' + su.name + '.' + so.name + '",' + 'dbo'

from sysobjects so, sysusers su

where so.uid =...

not sure why you want to do this unless you want create objects under different users...

setuser user1

go

....TSQL

setuser

go

setuser user2

....TSQL

setuser

go

possible that master db is corrupted.

if you have a backup of master db , restore it.

Theo, I believe you can automated your DTS Job if the excel files have fixed name.

1. write an activeX script to check if all files exists

2. transfer data from excel to tables.

one way to get around...

Eg. say you 3 sql tasks as shown below and Task2 is the one to bypass

Task1-----------> Task2------------->Task3

From task1 - output a value to a global variable

from...

how big are your textfields?

can you post your spreadsheet? I would love to give it a try.

You probably don't need activeX.

how about something like this....

1. create a global variable called HeaderID

2. create a query (stored proc) to output HeaderID and assign it to the global variable (using sql...

test what?