try to remove HPL\larry from administrators group of the troubled machine.

where in update?

the code above update all (197) rows 197 times.

put current of or unique where in update statement.

A manual insert from d1 into d3, capture the error.

just an idea.

Script to call iexplore.exe with url, then close itself after certain time.

xp_cmdshell to call the script.

what's reason of file not get deleted?

I would add /Q /F in del command.

Like "master..xp_cmdshell 'DEL /Q /F D:\SQLBackup\*.bak "

Not catch the error, but avoid it.

article

ms-help://MS.MSDNQTR.2004OCT.1033/dnsql2k/html/olapasandrs.htm has some workaround on the issue.

=DateAdd(Dateinterval.Day, -1, Today())

How did the parameter values populated in the select list? Use dataset to populate it.

use isqlw instead of osql.

You may have to specify -o in the syntax.

isqlw /? for syntax detail.

In query analyzer, Tools/Options, in Results tag, clear Print column Headers (*) check box.

Undocumented sp_msforeachdb stored procedure can help it.

Count user table for each db in the instance.

declare @sql varchar(400)

set @sql='select count(*) from ?.dbo.sysobjects where xtype = ''u'''

exec sp_msforeachdb

Assume id is alwayse increase and has index on it.

scalar function use max function can help.

Like

create function fn_rowbefore$ (@id int)

returns int

as

begin

  declare @ren int

  select @ren = max(id) from tablename...

sql profiler can help, use application name as filter

scalar function can help.

create function fn_groupbystr(sku int, customer varchar(5))

returns varchar(10)

as

begin

  declare @ren varchar(10)

  select @ren = case when @ren is null then '' else @ren + ',' end + SOURCE...

Empty string in varchar field <> Null.

ASP code check "" before try to call insert.