What is the difference between login and a user?
Answer Posted / dharmendra k. dixit
Login is the way of authentication into MSSQLServer,
and Users are the members of that Authentication as per
their Access rights for a specific DataBase.
Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
What is simple indexing method?
What is normalization? Describe its different types.
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is sql service broker?
What is report rendering ?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What is dirty page?
What are ddl triggers and types of ddl trigger?
If no size is defined while creating the database, what size will the database have?
what is difference between view and Dip.
What command would you use to add a column to a table in sql server?
List few advantages of stored procedure.
Where the sql logs gets stored?
How to perform key word search in tables?
What are wait types?