The following may or may not be relevant...

You could replace your WHERE clause with:

where FDate between '01 FEB 2004' and '29 FEB 2004' and datename(dw, FDate) = 'Sunday'

I'm stumped.  I would have suggested your SQL Server service was running under an account that's not a member of local administrators, but you've already discounted that.

I'll give it some...

You can proceed (in a complicated manner) if the database was in full or bulk-logged recovery mode AND you've taken regular tlog backups.

If the table was in simple recovery mode...

Was it the supersocket error recorded in the sql error log?

I've seen it before.  Sometime correctable (by a reboot) and sometimes not... when it occured on a cluster.

You should be able to emulate:

tAudit.ClientID Like IIf(IsNull([CurrentClientID]),"*",[CurrentClientID])

with:

tAudit.ClientID = IsNull(@CurrentClientID, tAudit.ClientID)

and, for the text field, emulate:

tAudit.ActionType Like IIf(IsNull([CurrentType]),"*",[CurrentType]) 

with:

tAudit.ActionType Like IsNull(@CurrentType ,"%")

I once got initial FT problems because I'd removed the builtin/administrators login.

I've seen T-SQL code that commits every record.  Although it's slow I have never seen this 1-row-per-page situation occur. 

I think it is unique to DTS transforms, or at least...

From experience, in such situations MS usually request that you follow their suggested techniques for detecting blocking.  If that's what they've suggested, then follow their advice.  It often has good results...

dbcc inputbuffer will only log the command used to execute the first SP if there's a chain of SPs utilised.

I'm with Kenneth.  Use Profiler.  Not that you'd have it running...

What does DBCC SHOWCONTIG return for each table?

If it's any consolation, existing system functions exhibit the same behavior.  Eg.

create table x

(id int identity,

name varchar(30) constraint checkname check (fn_chariswhitespace(name) <> 1))

Server: Msg 195, Level 15, State 10, Line...

My score... with someone else's name.

Try something like:

select ename, replicate('*', isnull((convert(int, sal) / 100),0)) from emp

Cheers,

- Mark

Dude226,

Is your remote login timeout set to zero (infinite wait)? Or, is there a firewall between the servers?

A personal preference of mine is that the live server just does...