Just a wild shot :

What (type of) account is serving Scheduled Task ?  Maybe it does not have the authority to access the batch or osql

the best thing you can do is to use query analyser and use the "predict execution plan" (ctrl+L)  or  "show execution plan" (ctrl+k) option to check out what it's doing.

- Any drivemapping involved ? use UNC in stead of drive-letters.

- capture your output

    --> for the batch for osql use the -o parameter (check bol)

like always, it depends on the usage of your table.

400 columns/tb  and normalized ?   I'm in no position to judge but this seems...

For the moment I'm running both at my windows xp sp2 without a problem

I started with the sql2k-personal edition, then installed my 2005...

Thank you for the replies.

For the moment, none of the applications has a specific need for a non-default collation.

The only way we may get into troubles is with our DTS-packages...

Once devs are pushed toward using parameters, they get confused as to why their sp is not reused and has many compilations when in use.

The reason is most of the...

in sql2005 use the xml-datatype

I just took a look at the way biztalk handles it, and they are using a mix of ntext...

dts supports a number of different connection-objects, provided by the dts-environment itself.

e.g. oledb / sqlserver / text / odbc / access ...

open dts and create a new package :  you'll...

you could fall back to the windows scheduled tasks  and use SQLCMD to execute your backup commands

Like many of us, you'll get in troubles when using system-objects other than INFORMATION_SCHEMA.

Make the effort to adapt to INFORMATION_SCHEMA-use.

You can stil use the sys.sysobjects stuff. So...

Are you looking for set deadlock_priority low ?

This way the executed statement is prefered victim for deadlock handling.

you could off course always select 50 columns

e.g. set @sqlquery = 'select yourcol1, yourcol2, null, null, null,... from yourtabel '

I guess you can alter the system-db's dblevel without a problem.

You'll also notice the (db) reports for e.g. space usage, will not work, but give you an errornotification that the...

Did you find a solution ?

I'll be out of the office until 01/25