Answer / Banti

In SQL Server, version 6.5 used SAS (SQL Authentication Service) for authentication while version 7.0 introduced Windows Authentication (also known as Integrated Security). The main difference lies in the method of authentication: SAS uses SQL Server-specific user names and passwords, whereas Windows Authentication relies on the security context provided by the operating system.nnIn version 6.5, you could have mixed-mode authentication that supports both SAS and Windows Authentication. However, it's recommended to use only Windows Authentication in modern versions of SQL Server.

Explain about protocol layer present in SQL server?

1 Answers  

---

How to get last system shutdown time in Sql server when restarted system?

1 Answers  

---

What is sql sandbox in sql server?

1 Answers  

---

What is the STUFF function and how does it differ from the REPLACE function?

2 Answers  

---

how to get the automatic backup of the database in the sql server

4 Answers  

---

What are the types of sql server?

1 Answers  

---

Explain full-text query in sql server?

1 Answers  

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---

What is difference between standardization and normalization?

1 Answers  

---

What stored by the master? : sql server database administration

1 Answers  

---

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1 Answers  

---