Windows authetication is certainly more secure and more easily managed (allocating permissions to Windows groups, centralising security at the Windows level) BUT.....plenty of vendor supplied packages assume mixed mode authentication...

Also this rather wonderful script which checks stored procedures and functions for incompatibilities:

http://www.sqlservercentral.com/scripts/Compatibility/62093/

The Upgrade Advisor is OK but not sufficiently detailed - I can't get it to do...

Sounds compelling to me, esp. the '2 versions to get it right' argument (6/6.5, 7/2000). Also I can now say that leaving most of our Servers on 2000 was part of a...

Not entirely relevant but Joel Spolsky (http://www.joelonsoftware.com) who as you know is pretty whizzy devotes a lot of time and thought to software testing. His latest blog post mentions ...

Also check your SQL database is large enough to receive all the Oracle data. It's probably set to autogrow (the default) but dynamically expanding a db device takes Server resources.

Are you...

PS I can't post the code, my employer will have my guts for garters if I do.

The main select involves 14 (FOURTEEN) inner and outer joins and several of the...

Thanks Jules & Andrew. I've had a busy couple of days but I'll look at the MSDN article & parameter sniffing later today.

Thanks for this - I created the procedure with recompile but it always took ages which reinforces the idea that its to do with the execution plan.

Pinning execution plans...

Yeah, I like them too in general. Although some of the 'off topic' Editorials deal with local things, the same issues (globalisation, offshoring, lousy employers, takeovers destoying good businesses) affect...

This is the first time, but unfortunately probably not the last time, that I've heard the acronym SOX in relation to audits as opposed to Boston or things you put...

Eureka...granting read-only access on the relevant root folder to the SQL Server Service account has fixed it and I can now run SQL Server under a non-local admin account. Good bit of...

Hi

I'll try granting read-only access to the Service Account from root downwards (That post wasn't mine by the way). EM only grants access to the MSSQL folders themselves.

So it could all go wrong again when I apply the next SP - great! I'm coming to the conclusion it's just not worth the hassle and the best thing is...

I've got somewhere with this now....it seems to be a result of inadequate permissions granted to the SYSTEM account, I will speak to someone here tomorrow.

I have to log onto the Server desktop as the 'ordinary' (not local admin) user to test this - currently speaking to the the Server admins to get this set up. Will...