truncate clears the whole table and frees the pages in use by the table.

Delete is a logged operation and can have conditions. pages in use by the table are freed...

It will be more interesting when :

1) make your timestamp_last_update a datetime column !

2) always update the last_update_error (make it INT)

set @SQL_Error = @@error

if @SQL_Error = 0

begin

update T_TableLoadData

    set...

if you are not using a where clause , you could use "truncate". see BOL

Try to perform many small chunks of transactional deletes to avoid blocking.

SET ROWCOUNT 1000

declare @Nrows int

set...

- doesn't Lotus Enterprise Integrator  have any error-reporting feature ??

- you could create a parameter-data containing Table_name and timestamp_last_update and then add as last statement of each table-handling block :

 update...

thanks for your time.

Instance_2 is using port 2446

Instance_3 is using port 2072

they reside at the same server.

Regarding the udp 445 : I have always been able to connect to instance_2,...

you might want to use :

exec sp_depends  @objname =  'object'

documented in BOL

these declares tell us zip.

post the sp code so we can get an impression as to what may be going on.

If you only have one location per machine that is not null, this will work.

update T1

  set location = T2.location

from yourtableowner.yourtable T1

inner join yourtableowner.yourtable T2

on T1.machine = T2.machine

and T1.location is null

and...

I use this.

It gives me not only the ip-address, but also the domain-suffix for the server

 CREATE TABLE #tIpInfo (vlgnr smallint not null identity primary key, IpAdres varchar(500))

declare @DosCmd varchar(100)

 if...

keep in mind that that is dynamic sql  !  http://www.sommarskog.se/dynamic_sql.html 

keep in mind that that is dynamic sql  !  :ermm http://www.sommarskog.se/dynamic_sql.html&nbsp

IFAIK you can only restore 1-1 (logical name vs filename) using restore database.

What you could do is :

- restore the full database to its new server

1) You'll have to stop/start sqlagent if it is the first alert you've defined where sql has to perform some stuff.

2) keep up...

I'm glad it worked.

tip of the day : Avoid running with uid=sa in _any_ environment.

yep, I noticed I'd forgotten to mention it

btw we have just been hooked up to a...