Yes it is only one account I have found. I tried to run sp_cycle_errorlogs as the account on the old server and it tells me that only members of sysadmin...

If you cannot use autogrow would running a dbcc shrinkdatabase on tempdb help?

I am currently testing moving from sql7 to new server with sql 2000.

These resources should help

knowledge base article 314546 and 240872

Also 2000 Books on line  selecting a SQL Collation.

Things to...

Thank you all for your help.

I resolved the issue by running rebuildm.exe

System and user databases both share same collation now.

I didnt realise that the user databases would be lost....but you...

Thanks Slolic.

In test I have moved user dbs using restore and have noticed that the collation on these is different to the collation on the system databases. Anyone have experince...

Bill Thanks for your post

I have 2 gb free on E & F and 13 gb free on G.

Does the tempdb need to be so large at 1.2GB?

How can I...