I can strongly recommend Ideras SQL diagnostic manager

at £450 per server it's a bargain. this should then give you a report on the slowest running Queries and procedures...

Microsoft don't state that there is a an upgrade path to std/enterprise edition from personal, however from past experience i can confirm that you can upgrde.

this should minimise your downtime....

has anyone come up witha fix for this yet ?

I'm getting a similar error - although this is only happening when not using connection pooling.

It appears that connections are not...

the response from idera was so slow that i posted it here first, but it appears that contra to their installation requirements and pre-requisits you must have SQL server...

funnily enough thats my script!!!!

i know you're all jumping to conclusions here...... but i post a lot of scripts!!! and this one has been no-where near that particular customer...

the issue...

fortunatley as part of all upgrade work we do for that customer we always script out the database design in case we need to make changes

so i've got a...

remi - easy on the happy pills!

ERIC - that looks suspiciously like a TI/99-4a on your picture

the reason c generates that error si that the final prameter of the last sp_dboption dies not use ' - they may look like ', but it's not.

you'll see it...

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...