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 |
|
anitha2324
Starting Member
18 Posts |
 Posted - 2008-05-03 : 01:12:24
|
| Hi All,Is there any sql query to find out the spid of the current running open connection ( which you are using now ) in sql server 2000 database.(not all the opened connections i need only the spid of the current one which am using now ) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-03 : 01:35:55
|
| I think you can use @@SPID for that. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 12:50:41
|
| select @@spid |
|
|
|
|
|
|
spid of current open connection