Where do you think the users names and passwords will be
stored in sql server?
Answer Posted / mallikarjun
Yes. login names and passwords stored in sysxlogins table
in master database.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is indexing a document?
Tell me what is sql profiler?
Mention the command used to rename the database.
What is trigger explain with program?
What is conditional split?
What is a partitioned view?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is read committed?
Define synonym?
Do you know clustered and non-clustered index?
Explain syntax for viewing, dropping and disabling triggers?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is isolation levels?
How to create a large table with random data for index testing in ms sql server?