Where do you think the users names and passwords will be
stored in sql server?
Answers were Sorted based on User's Feedback
Answer / guest
They get stored in master db in the sysxlogins table.
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / mallikarjun
Yes. login names and passwords stored in sysxlogins table
in master database.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ricky
it is stored in th sysxlogin table of the master database..
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / dinesh sharma
But In Sql Server 2005
Have a Stored Procdure
sp_change_users_login
| Is This Answer Correct ? | 3 Yes | 3 No |
What is save transaction and save point?
What is the difference between getdate and sysdatetime?
Is sql server free?
Why we use trigger in sql server with example?
What is the difference between update lock and exclusive lock?
what is the basic diffrence betn a col declared in char(1) and in varchar(1)
Explain Active/Active and Active/Passive cluster configurations
What are “unrepeatable reads”?
What are the types of table?
How many types of cursor type are there?
how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...
7 Answers ADP, Satyam, Tech Mahindra,
i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)