Answer Posted / ram suresh.l

While u create a user login in enterprise manager,u will be
given an option of creating the user with windows
authentication/SQL server authhentication mode.
You can choose the appropriate one

What is for xml in sql server?

686

---

How do I clean up sql server transaction log?

744

---

Explain few of the new features of sql server 2008 management studio

685

---

Explain tablesample?

729

---

what is the difference between Delete and Truncate command in SQL

812

---

---

What is the use of “join” in sql server?

756

---

What are the advantages of log shipping?

735

---

What are the purpose of Normalisation?

800

---

What are the types of sql server?

699

---

How to verify the port number of the sql server?

718

---

What is row_number()?

771

---

What is data compression? : sql server database administration

704

---

What are null values in ms sql server?

756

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

792

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

734

---