database probably in use by reporting services, stop this service before doing the restore, restart reporting services afterwards

look up sp_attach_db

was one of your databases in suspect mode before you started the upgrade? I think the error is quite explicit.

the database should still be marked suspect so fix that issue...

use column 'type'

description of possible values here

untested SQL2005 and above:

select name from master.sys.server_principals where IS_SRVROLEMEMBER ('sysadmin',name) = 1

union all

select name from master.sys.server_principals where IS_SRVROLEMEMBER ('serveradmin',name) = 1

any version but will be deprecated:

select loginname from syslogins where...

backup\restore still a possibility or SSIS. If this is nightly I can see your point about backup\restore as there are number of things you should run post the upgrade.

If you...

Gail just asked my question for me.

Is it because this is a repeating process or just because you dont want to bring the users over?

grant the sql service account access to the folder you are trying to create the database file in.

was your question answered in this thread?

most adverts suggest companies want breadth, but when it comes down to it for 90% of jobs they want good depth of knowledge in a small range of areas.

so don't...

err, backup and restore?

this error is usually an indication the server is under stress. a change was made in SP4 so 17883 errors produce more info to aid troubleshooting (by microsoft).

but as SQL2000...

I've tested it - only 1 cpu was ever used.

as I do not seem to be trusted - from a 'trusted' source 🙂

http://technet.microsoft.com/en-us/library/ms188388(SQL.90).aspx

in the maxdop section -

'Parallel index operations are available only in SQL Server 2005 Enterprise Edition....

read the whole thread, thats no of processors standard edition uses for index rebuilds, not how many it is licensed to use.