i've found instances in EM where it looks as though the database is in simple, but it never truncates.

so I always use ALTER DATABASE SET RECOVERY SIMPLE/FULL

though my colleague here...

Typical -

when fault finding on a system you go for the most obvious errors before delving into minutiae

I think they should give us the points for finding the...

yeah - i just got bummed by it too!

185 Gb, but i can't be bothered to jam up my test server and also i don't think i have enough t-log space

I've run the following to mimic your package

i get the following error log, however all of my new logins that i created are transferred correctly

Step 'DTSStep_OMWCustomTasks.OMWTransferLogins_1' failed

Step Error Source:...

Unless i'm mistaken - and there's every chance i could be.

DROP table is logged. if you have 10 million rows of data your drop table will generate a huge log...

As a matter of practice with large tables I always perform TRUNCATE TABLE before i drop the table

I think the key thing here is that the Upsize is USELESS

I make a point of always re-linking my tables.

it's the same with views - create a view that...

i'm guessing then that this is one of the settings on the options menu of query analyser......

but i'm not sure that i can see any that do this.

joyeux,

an unspecified error - (Erreur non spécifiée)

why can't they make these a little more helpfull ?

I thought so

Does anyone know if any of the later versions (particularly XI) can do this

i might be able to persuade teh customer to upgrade

i think he means profiler trace

how are you sending it to text file ?

via bcp? dts? query analyser?

i've seen it done this way as the text of a job in SQL agent

xp_cmdshell 'isqlw.exe -S myserver -d master -U sa -P password -i c:\script.sql -o results.csv'

although surely doinc...

I've come across this exact problem in the past and i can confirm it does affect access with linked tables held on SQL server.

I can't remember how i got round...