Even though you've done a subst, SQL doesn't know about your R: drive. You need to:

EXEC master..xp_cmdshell 'subst R: F:\BACKUP'

EXEC master..xp_cmdshell 'mkdir R:\FULL'

My reading of the second lot of statistics is that you're sending nothing to the server and therefore getting nothing back. Everything's zero, including network stats. Am I...

Grant,

I installed version 1.1.0.8 under SQL 7 SP4 (SQL log shows "Using 'xpsmtp70.dll' version '2002.08.12'") and was unable to replicate the problem for any combination of normal and unicode data...

Apart from the 1 line BOL and MSDN dedicate to it, I can find very little. I can only assume that if it's high and the server is processing...

Does the job contain any e-mail notification? If so, maybe try it without such notification and see if it runs to completion.

If your original (FTP) job is still executing, can it be stopped with a simple "stop job" through EM?

Carl,

When you do a test run (non-scheduled) of the package, do you do so logged on to the SQL box itself, or using client utilities from your workstation?

Jon,

6 hours is an extraordinarily long time for a 45gb database. Normally I'd say your tape drive needs looking at, except for the fact that it's about half the...

I'm confused, or more likely misreading the problem. Won't "IF Update(column_name)" be either true for all rows affected in a set-based update, or false for all rows?

...further to that, the database had to be called "victimdb" but no longer works on SQL2k anyway. You can stop mssqlserver and then play around with a hex editor...

In SQL 6.5 (and sybase) I recall a "DBCC CORRUPT" command, for training purposes. But I also think the database had to be called "corrupt". I'll investigate further...

...

Frank,

If it's a maintenance plan job, look at the report specified on the plan's reporting tab. If you haven't requested a report then do so.

Or, run a transaction log...

master..xp_cmdshell will let you run host commands from QA/ISQL/OSQL. Be careful not to run things that will pop up a dialog box or prompt for input because it'll just...

Sorry but you've caught me out... when I said "We switched to an Oracle-supplied driver" I meant that someone else in the team did the work while I shared the...

Can only suspect it's by design. Operations on MONEY fields return a MONEY field. Operations on DECIMAL return DECIMAL. The difference is that DECIMAL operations will adjust...