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
Does the unique constraint create an index?
What is the maximum size of column in sql server?
What is the purpose of the master database?
How to select an exiting database using mssql_select_db()?
Explain different types of locks in sql server.
Define compound operators?
What can be used instead of trigger?
What are the different authentication modes in sql server? How can it be changed?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
Can we use having clause without group by?
Do you know the cursor types?
How to convert numeric values to integers in ms sql server?
What are approximate numeric data types in ms sql server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How to create percentile function?