SQL Server Database Administrator Question:
Download Questions PDF

What is the difference in Login Security Modes between v6.5 and 7.0?

Answer:

7.0 doesn't have Standard Mode, only Windows NT Integrated mode and Mixed mode that consists of both Windows NT Integrated and SQL Server authentication modes.

Download SQL Server DB Administrator Interview Questions And Answers PDF

Previous QuestionNext Question
Can we have a nested transaction?What is lock escalation?