Answer Posted / sqldba29

I want to give access to a new user (example "user A") same
access as another existed user for (example "User B'").

User B has access to 8 databases in one server... (Read,
write, ddl)

My question is, what are the ways to give the access
to "User A"... or we have to open each database of "user B'
has and see his/her permissions on that database and then
open the "user A" and give the permission accordingly.

If you are doing any differently please help me.

What happens if the update subquery returns multiple rows in ms sql server?

1169

---

Which sql server table is used to hold the stored procedure scripts?

1109

---

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1147

---

how to use DTS package in 2000,2005,2008 in sql server

1902

---

what is a live lock? : Sql server database administration

1017

---

What do you mean by an execution plan? Why is it used?

1075

---

Mention the different authentication modes in sql server.

1105

---

What is data source in connection string?

956

---

Do you know the policy based administration feature of sql server 2008?

1000

---

How global temporary tables are represented and its scope?

1015

---

what is a correlated sub-query? : Sql server database administration

992

---

Explain differences between web edition and business edition?

119

---

How many types of database relationship in sql server?

1100

---

Is sql server implemented as a service or an application? : Sql server database administration

995

---

What is clr ddl trigger?

1034

---