How to create logins using windows Authentication mode?

Answer Posted / madan

sp_grantlogin'Domainname\loginname'

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between rownum and rowid?

670


Do you know what is replace and stuff function in sql server?

677


what is the information that can be stored inside a bit column? : Sql server database administration

706


Difference between report and query parameter.

803


What is bit data type?

797






You are doing log shipping due to some reasons it is failing. How you will proceed from there

1753


What are the advantages of using a stored procedure?

710


What methods do you follow to protect from sql injection attack?

702


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

1914


What are the differences between union, intersect, and minus operators?

763


How to find tables without indexes?

781


Is the order of columns in the set clause important in ms sql server?

708


mention different types of relationships in the dbms?

699


How self join is different from outer join?

790


What are statistics?

778