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

Call by value and call by reference in procedure and function, with NOCOPY.

1342


Tell me what is use of except clause? How it differs from not in clause?

993


List out what other servers you can use with ssrs?

145


What is transaction server distributed transaction?

1124


What stored by the msdb? : sql server database administration

1049


How to run sql server 2005 books online on your local system?

999


What is the maximum size of column in sql server?

938


Explain index in sql server?

1061


Which language rdl files made of?

141


Do you know what is a with(nolock)?

1101


How to connect ms access to sql servers through odbc?

1067


What is the purpose of linked server configuration in sql server?

1087


How many triggers are possible per table?

1138


Explain following error properties?

1056


What are transactions in sql?

1124