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
What is difference between rownum and rowid?
Do you know what is replace and stuff function in sql server?
what is the information that can be stored inside a bit column? : Sql server database administration
Difference between report and query parameter.
What is bit data type?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
What are the advantages of using a stored procedure?
What methods do you follow to protect from sql injection attack?
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
What are the differences between union, intersect, and minus operators?
How to find tables without indexes?
Is the order of columns in the set clause important in ms sql server?
mention different types of relationships in the dbms?
How self join is different from outer join?
What are statistics?