Well I sat down with the user and tried some queries while running a server side trace. Nothing seemed to be making much sense, so just tried installing SSMS and...

Just tried it on the test server and the query took 2 seconds and no change in log space for tempdb

Currently I'm using DBCC opentrans(tempdb) to find the session causing...

So if I run the query again I wont get the same changes in TempDB?

Install SQL 2000 first, make a note of where you put the tools and management console. Make sure its not the same location for the SQL 2008 install.

SQL 2008 is...

Ah I was using the x86 download and I should have been using the AMD I64 download even though I have intel processors :blink:

Have you tried add/remove programs ?

Technically not a lot from the dataengine point of view. You have to remember that not all SQL is cluster aware (SSIS for example) so sometimes you have to be...

use msdb

select * from dbo.sysjobsteps

Should show you steps for all jobs.

Could you tell us more about the server setup? Are they all in an AD or workgroup? Are they even on the same network? What rights do you have over...

i would consider a server farm to be two or more sql servers. Its a vague term and it sounds like your vendor doesn't know anything about sql instances, so...

I'm running 2k on half of our w2k3 64bit cluster. Only problem I had was when installing to over-ride the windows search service.

then you want to check out subscripion and publication Replication

Problably best to use CE and setup a merge/replication between them and the SQLEE server.

Its a bit tricky to setup though

Maybe to fix know bugs and issues

http://support.microsoft.com/kb/888799

but if you've been happy with SP3a until now then maybe you should be looking at upgrading to SQL2005/2008

Check the version of your management tool and your database server. You will probably find that your managemet tools need a service pack.