Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between update_one and auto_fix?
- 3 Answers
- 11172 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / aviral nalwat
AUTO_FIX matches based on the user alias in the DB to a
login account.
UPDATE_ONE allows you to specify the alias mapping to the
login account.
See BOL for more detail if needs be.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / karthik
Only members of the sysadmin fixed server role can specify
the Auto_Fix option. Only members of the sysadmin or
db_owner roles can specify the Update_One option.
| Is This Answer Correct ? | 3 Yes | 1 No |
Both are used as 1st param values with sp_change_users_login
s-proc
This is deprecated, should not be used.
more info: http://msdn.microsoft.com/en-us/library/ms174378.aspx
| Is This Answer Correct ? | 1 Yes | 0 No |
What are different types of subquery?
What are the differences between stored procedure and view in sql server?
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
List the different types of collation sensitivities in sql server?
how to avoid cursors? : Sql server database administration
Explain a checkpoint?
What are cursors in ms sql server?
I am using SQL Server 2005, I have some select and update statements in my query with WHERE clause I want to prevent these queries from SQL injection attacks. What are the steps and precautions to be taken for SQL Injection attacks? Does anybody have suggestions? Thanks in advance,
What happens when transaction log is full?
in tabase table having a column in it empname field is there which having 5 duplicate values is there i want deleted all the duplicates i want showing only one name only.
Is it ok to shrink transaction log?
-
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)
