Answer / aviral nalwat

AUTO_FIX matches based on the user alias in the DB to a
login account.

UPDATE_ONE allows you to specify the alias mapping to the
login account.

See BOL for more detail if needs be.

Answer / karthik

Only members of the sysadmin fixed server role can specify
the Auto_Fix option. Only members of the sysadmin or
db_owner roles can specify the Update_One option.

Answer / manoj pandey

Both are used as 1st param values with sp_change_users_login
s-proc

This is deprecated, should not be used.
more info: http://msdn.microsoft.com/en-us/library/ms174378.aspx

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 Answers  

---

What are sub-queries? Give example? In which case sub-queries are not feasible?

4 Answers   Infosys,

---

How to count duplicated values in a column in ms sql server?

1 Answers  

---

Can we use where clause with group by?

1 Answers  

---

what is cluster and nin-cluster index?

4 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

What stored procedure can you use to display the current processes?

1 Answers  

---

How can i change the column name.

13 Answers   HCL, Yardi Software,

---

What is meant by indexing?

1 Answers  

---

What is the use of for clause?

1 Answers  

---

What are subqueries in sql server? Explain its properties.

1 Answers  

---

What is data block and how to define data block size?

1 Answers  

---