Answer / Bhupendra

SQL Server supports two main authentication modes: SQL Server Authentication and Windows Authentication.
1. SQL Server Authentication: This mode uses SQL Server login accounts for authentication. The usernames and passwords are stored encrypted in the SQL Server database.
2. Windows Authentication: This mode relies on Active Directory or a standalone Windows account for authentication. With this method, the user is authenticated against the local machine or domain.

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1 Answers  

---

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

Difference between report and query parameter. Why do we need different type of parameter?

1 Answers  

---

How to use group functions in the select clause in ms sql server?

1 Answers  

---

How many nested transaction can possible in sql server?

3 Answers   Bank Of America,

---

What is a trigger in sql server?

1 Answers  

---

How to delete a database in ms sql server?

1 Answers  

---

Can we add our custom code in ssis?

1 Answers  

---

How to create a view on an existing table in ms sql server?

1 Answers  

---

Why Master database is required?

1 Answers   Abacus,

---

How can I create a new template for import ? : sql server management studio

1 Answers  

---