I agree with George. Test your move plan in a sandbox first. Detach, attach or backup restore both should work fine. I would also test the restore...

fast turnaround.

when you granted permissions to the user, what were the exact commands you issued? Or, in the case that you did it through the GUI, what was your process?

Your best bet would be to use a third party log app to try and match your transactions and data.

Did the user get added to a server role as well? Did the user get added to DBO within the database?

Botelo

You're welcome.

malleswarareddy_m (1/28/2010)

---

Dear all,

SET NOCOUNT ON

Does not reset the @@rowcount to 0.

@@rowcount is zero when we execute the system Defaults like as shown

set ansi_padding on

select @@rowcount

set nocount on

select...

This is correct, and thus makes the answer...

Please clarify "permissions on everything"

db_datareader gives a User permission to select from all tables within the database.

vstitte (1/29/2010)

---

My recommendation would be:

1. Create a database role or as many roles you will need.

2. Assign appropriate permissions to this role

3. Assign the users to the database role you...

Paul White (1/29/2010)

---

GilaMonster (1/28/2010)

---

Same as Seattle? That puts you 10 hours behind me. So if you meet at 7pm,...

Jeff Moden (1/28/2010)

---

CirquedeSQLeil (1/27/2010)

---

Jeff Moden (1/27/2010)

---

Alvin Ramard (1/27/2010)

---

Oh, before I forget Jason, we passed on to our local chapter membership the link to your blog about user group participation. ...

Jeff Moden (1/28/2010)

---

CirquedeSQLeil (1/27/2010)

---

I need a couple of volunteers if any are willing and have some spare time.

I am wrapping up an article and would like somebody else to review...

Paul White (1/29/2010)

---

It's a bit like SQL Server...