What is the difference between windows authentication and
sql server authentication

Answer Posted / hari

Windows authentication is more securable compare to mixed
mode authentication.

Is This Answer Correct ?    20 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What command do we use to rename a database?

609


How do you delete a data source?

539


How to enter binary string literals in ms sql server?

580


How will you add a dimension to cube? : sql server analysis services, ssas

550


What does COMMIT command do?

624






What do you mean by tablesample?

637


You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

543


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

1713


Explain system functions or built-in functions? What are different types of system functions?

561


What is a partition key?

519


what data regions are and what are the different data regions?

101


How to remove duplicate rows from table?

593


What is table-valued sub query?

563


What are the new data types are introduced in sql 2000?

500


What is nonclustered index on computed columns?

569