question

falisha avatar image
falisha asked

how to managse serializablity in SQL server?

hi to all. i have been given an assignment by my teacher that "how concurrency control & serializablity is managed in SQL server ?" i have searched alot on net but didn't get appropriate material.nad i'm really not clear about this topic. so pleaease tell me how it is being done?plz

sql-server-2005
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
TG avatar image
TG answered

That is a big topic. Have you tried looking through Books Online? concurrency in sql server is mangaged through transaction isolation levels. Try starting here an follow through the associated links:

Isolation Levels in the Database Engine http://technet.microsoft.com/en-us/library/ms189122%28SQL.90%29.aspx

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.