Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the diffrence between update_one and auto_fix?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the query of a table in sql server?

893


Difference between Logical Page and Physical Page in SSRS.

474


What is transaction server implicit?

1001


How to sort query output in descending order in ms sql server?

942


Can you explain what is sql server english query?

992


If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

975


Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1049


What is log in sql server?

1143


What is user-defined scalar function?

959


Tell me the use of keyword with encryption. Create a store procedure with encryption?

1003


Define indexes?

1037


Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

953


Sql server reporting services vs. Crystal reports.

131


What is the tcp/ip port on which sql server runs?

1149


Why and when do stored procedure recompile?

975