There needs to be controls on the production data. If it must be used for testing, and sometimes it must be, then it needs to be controlled, and you shouldn't...

Each set of permissions needs a different role.

If you need 20 people with read/write and 20 with read only, you need 2 roles.

A user can be in multiple roles, and...

I limit their ability in development. The reason has been to ensure that change is controlled and the don't make sweeping changes that cause a halt to development.

I would give...

What is the question? Is it Configuration Manager or model? You've put a lot of information in the post which doesn't make sense.

It sounds like you don't have the proper...

We don't allow post deletions. We do allow editing.

Please include more details about what you did.

If you create a login, and a user at the same time, that user should be able to log in. They won't see...

Possible it needs an update, but this desktop, is (I believe) 3 or 4 years old. The 6 year old one doesn't have SATA, and I've given up on that...

you would create roles in the database, and then you can assign SQL Server logins and database users to these roles.

You can assign these roles whatever permissions are needed.

The requirement for the path to exist could be a question. That's certainly valid, but this question asked "will this work" (originally) and then "can this work" (edited). In either...

Thanks and it's better. My wife even has assigned me some fence fixing chores today.

My limitations get a little lower every year. I'm OK with that, but I still try...

Thanks for the update, and for anyone else reading: check your drivers and firmware early when you have strange errors. I've seen this reported plenty of times with disks and...

I haven't tried Vista 64-bit, but on my ADM 64-bit desktop, I have XP32, and 2GB, and it's slow. I even have two SATA drives, OS on one, VMs on...

And did you install SQL Server? Or does BackupExec do that in a bare metal restore?

Typically (non BackupExec) process is to install Windows (or restore), install SQL Server (or restore),...

No points off for whining. I make plenty of mistakes.

However, if you complain, I would like to see you write a question, or even explain how you think this question...

Thanks everyone for the notes, and my sympathies do those of you suffering.

I'm much better today, can stand up/sit down with pain, even bend over enough to lift the toilet...