Working with two sessions

[jrosh]

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.

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/

[jrosh]

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?

How can i do it with my PC?

What platform? OS (Window 7 or 8) or Window Server or Unix?

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?

You can do this (if you have Window Server):

http://social.microsoft.com/Forums/en-US/windowshpcitpros/thread/d4d9a518-210d-40e9-8638-77e23110cfb3

[jrosh]

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.