Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between windows authentication and
sql server authentication
- 7 Answers
- 23673 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ramadass
With windows authentication, we can not do database access
by giving role,permission where as we cand do it for SQL
server authentication.
We can not control the windows authentication user over the
DB.
Windows authentication user by default having the Admin
access in sql server. so we can not control them.
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What is the maximum size of column in sql server?
Explain different types of lock modes in sql server 2000?
Explain what is log shipping?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Difference between report and query parameter.
What is table value parameters (tvp)?
What is inner join? Explain with an example?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is the purpose of object explorer and its features? : sql server management studio
What are relationships and mention different types of relationships in the dbms
Why use cursor in sql server?
What is the use of custom fields in report?
How do I start sql server agent automatically?
How to create view in stored procedure sql server?
What is the New in SQL server 2008?
