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 |
|
YogeshDesai
Posting Yak Master
136 Posts |
 Posted - 2007-04-17 : 06:26:26
|
| Hi All,I have few questions in mind.1. Where can I look at active sql connections ? I use sp_who for this...Is there any other way2. how to find that SQL server 2000 is 32 bit or 64 bitYogesh V. Desai. | SQLDBA| |
|
|
NeilG
Aged Yak Warrior
530 Posts |
Posted - 2007-04-17 : 06:53:59
|
| There is sp_who2 that you can use and in sql server 2000 there is current activity in enterprise manager that will show you all that is happening on the server. |
 |
|
|
bpgupta
Yak Posting Veteran
75 Posts |
Posted - 2007-04-17 : 06:57:53
|
| use can use the sysprocesses tables to see the active connections |
|
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2007-04-17 : 09:45:50
|
| 1) I use sysprocesses. I would not use enterprise manager for viewing this.2) Use SELECT @@VERSION to see if it is x86 (32bit) or if it is something else. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-17 : 11:25:09
|
| Use 'sp_who2 active'. |
|
|
|
YogeshDesai
Posting Yak Master
136 Posts |
Posted - 2007-04-18 : 07:43:02
|
| hi Guys really thanks for your help to gain my knowledgeYogesh V. Desai. | SQLDBA| |
|
|
|
|
|
|
Active Connection ?