The actual problem turns out to be: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q329487 incase anyone else suffers the same fate as myself.

Thanks Andy, checked out the article and we're running SQL 2000 SP2. Also our Server is already on Full Recovery Mode. The interesting thing is that I switched the recovery...

Try this script for each user in the restored db to sync server logins with database users.

DECLARE @db sysname, @uid sysname

select @db = DB_NAME()

--First add normal user --

SET @uid =...

Just finished doing a similar thing where user uploads a csv file via ASP and clicks OK. this sets the new file as dts text file source and inserts/updates tables...

Had a similar prob. not long ago when trying to run cmd shell from dts pkg when dts is called by a job.

After pulling many hairs out we set...

After reading your reply and doing some old fashioned 'machine watching' I have found what appears to be the problem. The job to run the transaction log backup was created...

Thanks Andy... problem still exists, default db for login is set to the correct db.