Where do the SQL folders repldata,ftdata,jobs,log,data and backup sit?  Are they on C:\ or D:\?  Some bits of SQL Server are very specific as to where they reside e.g. device...

 Is there an F: \drive on the new server?  As the SQL Server and  the master, model and msdb files loaded on the F:\ drive of the original server, is...

Are you changing the path of the database when you restore? That is, having chosen Restore database, selecting the Options tab, double click in Restore As and changing the...

As I remember, the order to move the system databases is model, msdb then master.  Microsoft have got quite a bit on their site about this.

The other thing I've tried,...

"We have used SQL Server on VMs in a non-production mode. We have also used SQL Server on VMs for disaster recovery testing. "

When you wrote this, did you mean ...

I will doing a test restore from a backup just to see if these 'temp' tables disappear.  I have sent mail to the company to ask about clearing these tables...

Actually the user has existed on both the test and live server for over two years with exactly the same permissions and ownership.

That's why we are confused; this user was...

Yes there are.  We have tried the script against a test database with no users/owners in and one where we definitely know we have users who own objects with the...

We have tried the script against the relevant database but got no results.  When we deleted the element 'where uid <>1' everything came back as being 'dbo'

How could you test for who owned what before trouble sets in? 

We have already had the situation where deleting a user (when she left) couldn't be achieved as they...

We won't get the script until the beginning of next week so we will look at it then.  In the meantime, we are going back to the company to get...

They send us a script which we run through QA. 

I have presumed that he/she has checked that the database is there.  We have tried attaching and detaching ourselves, in the past, with no success.  We found that unexpected disasters...

Try this:  it has worked for us

You go to Control Panel, Administrative Tools and then Services.  Stop these services, in this order,

SQL Server Agent

MSSQL Server

Then start the services, in...

I must admit that I usually do write in Notepad  but occasionally then, when I've pasted into the message, I start to re-compose, re-read, amend and then get interrupted.  I...