Thanks Luis

Are there any steps I can take to try and find out the cause?

This is very bizarre.

I've just retested my code against all servers (2005/2008/2012) using a test login and it's all working fine.

I've created the user, adjusted the permissions and then deleted...

Thanks folks, looks like we've got some decisions to make.

Just out of curiosity, what the minimum amount of time between log ships (if that's a sensible questions?)?

We aren't using it for failover.

The mirrors will be snapshotted for use in reporting.

We need the data to run various reports on (that's on thr BI Edition server).

The mirror to...

I don't think we'll be getting Enterprise edition but I'll check.

My concern is that Business Intelligence edition won't mirror to Developer edition.

I'm assuming the new servers will be on the Business Intelligence Edition.

If my assumption is correct, will mirroring work?

Gail - Thanks for that, it never occurred to me that the computed column would cause such an issue. I've removed the column and everything's working (so far at...

Thanks folks.

I've been thrown in at the deep end before and (just about) managed to swim..... well, most of the time.

I'm just looking for something reasonably formal to fill in...

I'm in the UK (not sure if you need anything more specific than that).

I'll be doing mostly DBA work probably with a bit of development thrown in to keep occupied...

Thanks folks.

I've just run the same test Alan.B described and shown it to my boss.

I got (for a million rows) 203ms, 266ms and 47ms CPU time respectively.

He's still of the...

Thanks Lynn

John Mitchell - That's what I was trying to do and failing miserably.

John Rowan - I'm trying to keep the number of procs to a minimum (for ease of scaling)...

Thanks for the confirmation, it all seems to have worked anyway.

Now for a stupid question.

We're setting up a DEV server and a PROD server.

If I design an SSIS package on DEV, can I deploy it on PROD?

I'm going to try...

DOH! :blush:

Thanks for that. It was set to allow Windows only so I've changed it to Windows and SQL authentication.