Check on your source db (where mdf/ldf from).

If necessary, add these views (it should have if created from msdb).

Many factors effect estimated execution time, like cache hit rate, io speed, network throughput.

You do have EstimateCPU by turn on showplay_all.

should be showplan_all

DBCC SQLPERF ( LOGSPACE ) 

find out how empty it is.

fncSplitAgentBalance returns table which does not match scalar requirement in select statement.

One way to tackle the problem.

cursor through AsValuation, get ValuationAmount into @variable,

call fncSplitAgentBalance (2, @variable)

get result (select or...

winword insert Symbols is one place

information_schema.tables is a view in master (not sure in sql7).

Check on sp_helptext [information_schema.tables] to find it out.

³

nchar(unicode)

select nchar(0x2265)

results: =

Try to avoid the duplicated key.

insert into table

select ---- from insertTable

where not exists(select * from table where key = insertTable.key)

what is the value of print @servererror

when Server: Msg 17, Level 16, State 1, Line 1 happend?

Article PSS ID306212 describes the case.

It has basic guide for troubleshooting linked server error 7391.

Compare execution plans between correct and not correct may help.

sysdepends is a system table to look up.

Once find out all the objects, use dts to copy.

Try share the folder, then put the share on network (make it D drive) using net use.