Where sql server user names and passwords are stored in sql server? : sql server database administration
- 1 Answers
- 1133 Views
- I also Faced
- E-Mail Answers
Answer / Jitendra Prasad
SQL Server usernames and passwords are not stored directly in the database, but they are encrypted using the master key and stored in the sys.sql_logins catalog view.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to skip remaining statements in a loop block using continue statements?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What is the difference between referencing and joining?
What are a database and a data warehouse?
How to find the date and time of last updated table?
Whether the updations made to the views reflect the original records in the table
How can I create a plain-text flat file from SQL Server as input to another application?
What is the difference between set and select?
How to use order by with union operators in ms sql server?
What are extended events in sql server?
How to provide column names in insert statements in ms sql server?
Explain what is cte (common table expression)?
-
Oracle (3253) - 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)
