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 is difference between count (*) and count column?

838

---

What are sparse columns?

951

---

How to use union to merge outputs from two queries together in ms sql server?

1005

---

When to use null data driven subscription?

196

---

Should you normalize audio?

876

---

What are the dis_advantages of stored procedures, triggers, indexes?

2170

---

What the different topologies in which replication can be configured?

1019

---

What are the various editions of sql server 2017 that are available in the market?

842

---

What does man by sql wildcard characters in sql server?

991

---

Find first and last day of current month in sql server

972

---

What is the difference between deallocate cursor and close cursor?

1164

---

Do you know what are the reporting services components?

916

---

How to get the number of affected rows?

946

---

How can you check the version of sql server?

1045

---

How to declare and use cursor variables?

1072

---