Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
iqra
Starting Member
2 Posts |
 Posted - 2010-07-21 : 08:05:36
|
| Hello to all i'm new in sql server. i have table contain two column when i insert record in table with begin tran it lock the table. when i tried to perform SELECTION operation from another session it keep wait until i commit or rollback the transaction. whereas in oracle when a session insert or update a table its image copy is placed on undo tablespace where another session can do selection on data. IS it possible in SQL SERVER ?? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-21 : 08:13:19
|
| Set database to READ_COMMITTED_SNAPSHOT? |
 |
|
|
iqra
Starting Member
2 Posts |
Posted - 2010-07-21 : 08:17:20
|
i dont know how to check whether my db in READ_COMMITTED_SNAPSHOT or non READ_COMMITTED_SNAPSHOT. how to change this behavior quote:
Originally posted by Kristen
Set database to READ_COMMITTED_SNAPSHOT?
|
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2010-07-21 : 08:29:06
|
| To check current setting:select name , is_read_committed_snapshot_on from sys.databases where name = 'MyDatabase'To change lookup ALTER DATABASE with the option Kristen suggested above. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-07-21 : 08:45:58
|
| "how to change this behavior"Its in the SQL Documentation - available online or to download. |
|
|
|
|
|
|
how to prevent TABLOCK