adspace


What is the diffrence between update_one and auto_fix?

Answer Posted / manoj pandey

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1298


Is it possible to have clustered index on separate drive from original table location?

1039


What is a coalesce function?

1282


Can you index views?

953


What are the different subsets of sql?

1648


How do I start sql server 2017?

1015


What are wait types?

1248


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1022


What is an indexed view?

1021


What are the different types of subquery?

1233


How to connect php with different port numbers?

1184


do you know how to configure db2 side of the application? : Sql server database administration

1121


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8227


what is the difference between openrowset and openquery?

1191


How do I create a trace in sql server?

1118