What is the difference between login and a user?
Answer Posted / potula
login defines access privillege to sql server. A user
defines the accessible objects and rights the login has
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
how to do partition in sqlserver
what is a self join? Explain it with an example? : Sql server database administration
Can the “if update (colname)” statement be used in a delete trigger?
What do you mean by an execution plan? Why is it used? How would you view it?
What is RMS migrations?
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 security features are available for stored procedure?
How do I create an extended event in sql server?
How to get the definition of a user defined function back?
How do I view a stored procedure in sql server?
When a primary key constraint is included in a table, what other constraints does this imply?
What is sql server profiler?
Explain log shipping and mention its advantages.
What do you understand by triggers?