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.

Member Avatar for LastMitch

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/

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?

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.