0

I have an assignment where i should demonstrate concurrency controls.In order to do that i should work with two sessions in the same database in ms sql server. How can i do that.

2
Contributors
4
Replies
25
Views
4 Years
Discussion Span
Last Post by jrosh
0

I have an assignment where i should demonstrate concurrency controls.In order to do that i should work with two sessions in the same database in ms sql server. How can i do that.

Can you be more specific? Are you asking what is a concurreny control or asking for a query or code?

If you have a code that you have done some far then post it.

Rather than just posting a question not very specific what you are asking (either for a code or explaining what it is)

Read this (it's about understanding concurreny control):

http://codepalace.blogspot.com/2010/05/understanding-concurrency-control-in.html

and this:

http://www.sql.org/sql-database/postgresql/manual/mvcc.html

This link has examples for you to test it on your server.

http://cisnet.baruch.cuny.edu/holowczak/classes/9440/concurrency/

Edited by LastMitch: grammer

0

Thank you for the reply. I need the help on How to get two sessions in the database. I am working in my PC. I have insatalled SQLServer 2012 and management studio. I need to access a database as two different users to do this. How can i do it with my PC? or can i do it afterall?

I learnt that i need "two terminal sessions" and execute sql statements. How can I get that?

Edited by jrosh

0

I have windows 7 and SQL Server 2012 installed locally. I just want to simulate. simply as open two windows and run query which they would behave as two concurrent users.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.