Cheers Steve. Easy when you know how!

Thanks

The SSC homepage is currently advertising a "SQL Server MasterClass with Kimberly Tripp and Paul Randal" event. Well worth the time & money if you can make it!

Yes, they will be able to stop/start services via SSCM as well!!!

YES, via services.msc!

Still don't understand what you mean... are you referring to BUIILTIN\Administrators? Do you mean removing them...

A local or domain Windows Administrator can shutdown/restart the server including restarting SQL services.

But perhaps I haven't fully understood your question...

fantastic... told you it was easy! 😉

Have fun

Yes, that's right.

So your moving between SQL 2005 instances? My fault I attached the SQL 2000 ---> SQL 2005 script... The script below is what you need.

--To transfer the logins...

No, leave the database users alone, the provided script will 'match up' the sql...

Do you know how the sql login should be created in terms of permissions, passwords etc? If you do then just recreate the SQL login with the appropriate user...

Did you create the logins manually or by script?

Hi,

This is because a database user called 'MBL' already exisits in the database, you can check this by expanding databases, database_name, security, users.

Once the user has been deleted you can...

15 days?! are...

For my 2 cents, SQL Backup/Litespeed are definitely worth the cash - they provide a huge amount of value in ease of backup/recovery automation and are feature rich. If going...