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 |
|
thelak
Starting Member
5 Posts |
 Posted - 2010-09-23 : 07:41:00
|
| HI, I am new to sql , please tell me how to find open transaction in a sessionRegThelak |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-09-23 : 07:53:39
|
| select @@TRANCOUNT will let you know if there are any open transactions. |
 |
|
|
thelak
Starting Member
5 Posts |
Posted - 2010-09-23 : 09:02:10
|
| I am not working in T-sql please let me know how to do the same thing in sql server pleaseRegThelak |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2010-09-23 : 09:40:05
|
| errrrmmmm, T-SQL is SQL Server.. SQL Server was a product originally designed by Sybase and brought from them, therefore using a lot of the same features.If you are not working in SQL Server, then you are in the wrong place. |
|
|
|
thelak
Starting Member
5 Posts |
Posted - 2010-09-23 : 22:48:06
|
| sorry!am working in sql server only but it not belongs to microsoft(its not mysql) please guide me in thisam working in unix platform with oracle databaseRegThelak |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
|
|
|
|
|
sessions