when expantion is done "in process", you may get timeouts to the "expand file" request. SQLServer then says "...file full".

The request itself is not terminated, but is completed after...

from BOL :

WITH <termination>

Specifies when to roll back incomplete transactions when the database is transitioned from one state to another. Only one...

Maybe this udf can be used as a workaround :

if exists (select * from dbo.sysobjects where id = object_id('dbo.udf_Get_Last_DayNr'))

  begin

 Drop Function dbo.udf_Get_Last_DayNr

 print 'Dropped'

  end

go

Create Function dbo.udf_Get_Last_DayNr

(  @Start_DateTime AS datetime ...

Maybe you can read the reg-key from within your application's front-tier (not at the mid-tier or server) and have the timezoneshift delivered by your application.

Frank Kalis pointed me toward a way to find out the local timezone using the registry :

DECLARE @delta INT

EXEC master.dbo.xp_regread

'HKEY_LOCAL_MACHINE'

, 'SYSTEM\CurrentControlSet\Control\TimeZoneInformation'

, 'ActiveTimeBias'

,...

This is without a question a joint venture of DA and DBA.

But if you forget to have your standards supported by you top-level ceo your project...

in sql2k you can also use

alter database yourdb SET OFFLINE  WITH ROLLBACK IMMEDIATE

This way you avoid problems with reattatching the db at the same server and all users...

If you only want the userid - names , you can query against systables using Isql.

These are queries against the systemtables; I do not recommend to make an habit of it.

If...

take a look at : http://www.sqlservercentral.com/scripts/contributions/1130.asp 

Keep in mind that this will not work on encrypted procs in the system.

If you are only looking for...

Implemented it on my testserver and it went fine.

I always get errorinfo in jobhistory and jobstephistory when applicable .

ok, last shot ....

Can you post the fully scripted job and jobsteps ?

(EM\Management\SQLAgent\jobs and rightclick on your job \all tasks\script it)

try setting the jobowner to sa. SQLserver has some problems with nt-users as jobowner.

- except for the NOINIT / INIT thing it seams OK.

- What says the next line on the sqlserver log ?

- Who is the job-owner ? (script the job)

- can...

Can you detatch the db from EM ?

(rightclick and detatchdb)

- Can you post the jobs script (full !)

- and some job history overview ?