You can create a performance alert "percent log used" and execute a job

  backup the transaction log

  email you the information

So I get A problem because I'd like to publish the same article !!

My architecture Is the following :

Place  1: SQL Server and computers with MSDE . A merge replication

Place...

thanks I test it on pre production and the performance are better !!

Tom

I use an integer as primary key. I hope your comments will be useful.

Could you explain me why I should not use integer ?

Tom

Some collegues informs me about this point and users about prb of performances.

But the latch wait time , lock wait are good, network for the server too and transaction pretty low....

YEs but you have to do the same step for each tables !! But a good idea for a one shot !!

Tom

thanks, I solve the problem by using a activex componant with the RowsInError and RowsComplete properties.

Ts

which one ?

T

ok thanks, I have to create 10 temptables. Not dynamicaly but it will work.

thanks for your time !

Tom

Ok I think you're right.

But I have another question :

when you write 'temporary table' is it real sql temporary tables (##temp or #temp) ?

If yes, how to generate it...

Yes it is. but i thougth that it exists a function in DTS to do such a thing !

Thanks

Tom

Got it !!!!!!!!

I check my SQL on my stage DB server .

BUT GIVE THE SAME Physical NAME !!!!!

I modify It by alter database modify file...., Standard manipulation

But error...

1 & 2  : month is a number YYYYMM (unique identifier= a period).

startdate is a period

3 : I always have enddate of a record = start of a record for a...

A other question :

I make dbcc checkdb every nights on each DB.

The result is store in a file I send me by mail.

QUESTION :

how can I centralized the process by...

yes it does ! Thank you, I will create my proc with DB link