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 |
|
shannon
Starting Member
4 Posts |
 Posted - 2002-03-14 : 06:03:59
|
| Can anyone tell me how to set the transaction isolation level (not by running the statement> set transaction isolation level serializable)?I need to set it in the database itself as permenent or when ever the database starts up.....pls help....... very much appreciated if anyone drop some hints |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-14 : 07:15:40
|
| AFAIK it cannot be set as a server or database default. You must specify it before each transaction. Frankly, you don't need SERIALIZABLE for simple operations, it would unnecessarily drag down performance. |
 |
|
|
|
|
|
Transaction Isolation level