User ID's and Roles were assigned in the SQL 2000 server database.

Users were assigned to a role in sql2000 (role1 - 3 tables read only)

We copied the db's over to...

That's great news. Our databases are located on the SAN. So, after the in-place upgrade we were planning on doing a detach from the old server (in place upgraded)...

Thanks for the reply. We have other databases running in SQL2008 with a compatibility level of 2000 (80). So your recommendation is to do a side by side...

Yes, as a last resort. Just shaking my head on how the create script provided by Microsoft doesn't work.

I'll copy one fom another server and hope it works.

Thank You for all the replies, we got it working.

Yes, the database is in 'SIMPLE' recovery mode still. I did check that.

The following code returns no open transactions or processes:

DBCC OPENTRAN

or

SELECT * FROM sysprocesses where dbid = db_id('DBName')...

Thanks for the reply. I failed to mention in the original post that the VM server is vreated using P2V. The server name and all it's attributes are...

Great, thanks for the insight.

Thank you everyone for all the input. Much appreciated.

Dana

Thanks, for the quick reply.

Can all the setting be done at the same time and it looks like setting the maximum server memory or MAXDOP do not need a restart....

Thanks for the replys, I have left a message on programmers VM to see if problem is still on his PC. (other PC's worked fine connecting using 2008...

Can't see them in the user GUI. I can see them as administrator on my gui and on the server.

strangely, if the user goes to another PC, using SSMS...

Thanks for the reply. What permissions should I be looking for? They have db_owner access to the database on the linked server.

Do they need explicit read permissions to...

The answer to why we are doing this is to be proactive. We will be adding 100's of users and database interfaces in the next few months.

Steps to follow...

We are at WIN 2003 Enterprise. Cluster is only under enterprise edition.

Still trying to get an answer to why we are doing this.

I am trying to get that answer for a week now. All I know is the System Admin is trying to schedule a time to add it. I...