I dont think there is anything like a "scan for sql updates" like there is
for Windows but wanted to verify? As an alternative, is there a list
somewhere that will tell me post sp3a what security updates are available?
TIA, ChrisR
How do I know which version of SQL Server I'm running?
http://www.aspfaq.com/show.asp?id=2160
Credit to Aaron Bertrand for maintaining the list.
Geoff N. Hiten
Microsoft SQL Server MVP
"ChrisR" <noemail@.bla.com> wrote in message
news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>I dont think there is anything like a "scan for sql updates" like there is
>for Windows but wanted to verify? As an alternative, is there a list
>somewhere that will tell me post sp3a what security updates are available?
> TIA, ChrisR
>
|||Thanks Geoff and thanks to Aaron for the list.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:OPB5wmpcFHA.612@.TK2MSFTNGP12.phx.gbl...
> How do I know which version of SQL Server I'm running?
> http://www.aspfaq.com/show.asp?id=2160
> Credit to Aaron Bertrand for maintaining the list.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>
Showing posts with label updates. Show all posts
Showing posts with label updates. Show all posts
Friday, March 9, 2012
list of sql updates?
I dont think there is anything like a "scan for sql updates" like there is
for Windows but wanted to verify? As an alternative, is there a list
somewhere that will tell me post sp3a what security updates are available?
TIA, ChrisRHow do I know which version of SQL Server I'm running?
http://www.aspfaq.com/show.asp?id=2160
Credit to Aaron Bertrand for maintaining the list.
Geoff N. Hiten
Microsoft SQL Server MVP
"ChrisR" <noemail@.bla.com> wrote in message
news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>I dont think there is anything like a "scan for sql updates" like there is
>for Windows but wanted to verify? As an alternative, is there a list
>somewhere that will tell me post sp3a what security updates are available?
> TIA, ChrisR
>|||Thanks Geoff and thanks to Aaron for the list.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:OPB5wmpcFHA.612@.TK2MSFTNGP12.phx.gbl...
> How do I know which version of SQL Server I'm running?
> http://www.aspfaq.com/show.asp?id=2160
> Credit to Aaron Bertrand for maintaining the list.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>
for Windows but wanted to verify? As an alternative, is there a list
somewhere that will tell me post sp3a what security updates are available?
TIA, ChrisRHow do I know which version of SQL Server I'm running?
http://www.aspfaq.com/show.asp?id=2160
Credit to Aaron Bertrand for maintaining the list.
Geoff N. Hiten
Microsoft SQL Server MVP
"ChrisR" <noemail@.bla.com> wrote in message
news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>I dont think there is anything like a "scan for sql updates" like there is
>for Windows but wanted to verify? As an alternative, is there a list
>somewhere that will tell me post sp3a what security updates are available?
> TIA, ChrisR
>|||Thanks Geoff and thanks to Aaron for the list.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:OPB5wmpcFHA.612@.TK2MSFTNGP12.phx.gbl...
> How do I know which version of SQL Server I'm running?
> http://www.aspfaq.com/show.asp?id=2160
> Credit to Aaron Bertrand for maintaining the list.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>
list of sql updates?
I dont think there is anything like a "scan for sql updates" like there is
for Windows but wanted to verify? As an alternative, is there a list
somewhere that will tell me post sp3a what security updates are available?
TIA, ChrisRHow do I know which version of SQL Server I'm running?
http://www.aspfaq.com/show.asp?id=2160
Credit to Aaron Bertrand for maintaining the list.
Geoff N. Hiten
Microsoft SQL Server MVP
"ChrisR" <noemail@.bla.com> wrote in message
news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>I dont think there is anything like a "scan for sql updates" like there is
>for Windows but wanted to verify? As an alternative, is there a list
>somewhere that will tell me post sp3a what security updates are available?
> TIA, ChrisR
>|||Thanks Geoff and thanks to Aaron for the list.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:OPB5wmpcFHA.612@.TK2MSFTNGP12.phx.gbl...
> How do I know which version of SQL Server I'm running?
> http://www.aspfaq.com/show.asp?id=2160
> Credit to Aaron Bertrand for maintaining the list.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>>I dont think there is anything like a "scan for sql updates" like there is
>>for Windows but wanted to verify? As an alternative, is there a list
>>somewhere that will tell me post sp3a what security updates are available?
>> TIA, ChrisR
>
for Windows but wanted to verify? As an alternative, is there a list
somewhere that will tell me post sp3a what security updates are available?
TIA, ChrisRHow do I know which version of SQL Server I'm running?
http://www.aspfaq.com/show.asp?id=2160
Credit to Aaron Bertrand for maintaining the list.
Geoff N. Hiten
Microsoft SQL Server MVP
"ChrisR" <noemail@.bla.com> wrote in message
news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>I dont think there is anything like a "scan for sql updates" like there is
>for Windows but wanted to verify? As an alternative, is there a list
>somewhere that will tell me post sp3a what security updates are available?
> TIA, ChrisR
>|||Thanks Geoff and thanks to Aaron for the list.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:OPB5wmpcFHA.612@.TK2MSFTNGP12.phx.gbl...
> How do I know which version of SQL Server I'm running?
> http://www.aspfaq.com/show.asp?id=2160
> Credit to Aaron Bertrand for maintaining the list.
> Geoff N. Hiten
> Microsoft SQL Server MVP
>
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OjEFDXpcFHA.3620@.TK2MSFTNGP09.phx.gbl...
>>I dont think there is anything like a "scan for sql updates" like there is
>>for Windows but wanted to verify? As an alternative, is there a list
>>somewhere that will tell me post sp3a what security updates are available?
>> TIA, ChrisR
>
List of Logged ON USERS
Hi All,
I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
the LIST of Users logged on to the SAME DB, so that I can Inform them to
Logout from the DB before I start the Process.
How Do I know the List of Users that have logged on to the DB - The List
should not include my login ( or ) a comment beside my login.
Thanks
Prabhat
One way would be to make a copy of the sp_who2 procedure and modify it to do
what you want. It wouldn't be difficult. Call it sp_who3 for example
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>
|||Hi,
Apologies if this is a silly statement. You can use Enterprise Manager to
view a list of currently active connections. Go to Management | Current
Activity | Process Info
This will give you a list of current active sessions although it does
include things like the Checkpoint and Lazy Writer processes. As long as you
can filter these out you should be able to see which users are connected and
which application they are using.
Hope this answers your question. If you already knew this then I apologise
for stating the obvious
Cheers,
IM
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>
|||Prabhat
One of the many options is
select hostname from master..sysprocesses
where spid>50 and dbid=db_id('databasename')
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
|||Using Sysprocesses is the way to go... but it may change with SQL 2005, so
make sure you insulate yourself so you can make changes easily.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
|||"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
Use the sysprocesses table on the master database.
If you want, you could also try the application that I have developed called
DBMonitor. This will inform you of the users connected to each database, if
the users are actually running any commands, and what commands they are
running.
You can find a copy at http://dbmonitor.tripod.com
David Rowland
DBMonitor version 1.2 out now! http://dbmonitor.tripod.com
Email Alerts, logging, performance stats, process information!
Only $49.95
|||Thanks Uri and All for giving the Suggestions.
I think the the sysprocessess is the best option to go with and as Wayne
Snyder suggest I should be ready for 2005 also.
Thanks
Prabhat
> One of the many options is
> select hostname from master..sysprocesses
> where spid>50 and dbid=db_id('databasename')
I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
the LIST of Users logged on to the SAME DB, so that I can Inform them to
Logout from the DB before I start the Process.
How Do I know the List of Users that have logged on to the DB - The List
should not include my login ( or ) a comment beside my login.
Thanks
Prabhat
One way would be to make a copy of the sp_who2 procedure and modify it to do
what you want. It wouldn't be difficult. Call it sp_who3 for example
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>
|||Hi,
Apologies if this is a silly statement. You can use Enterprise Manager to
view a list of currently active connections. Go to Management | Current
Activity | Process Info
This will give you a list of current active sessions although it does
include things like the Checkpoint and Lazy Writer processes. As long as you
can filter these out you should be able to see which users are connected and
which application they are using.
Hope this answers your question. If you already knew this then I apologise
for stating the obvious
Cheers,
IM
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>
|||Prabhat
One of the many options is
select hostname from master..sysprocesses
where spid>50 and dbid=db_id('databasename')
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
|||Using Sysprocesses is the way to go... but it may change with SQL 2005, so
make sure you insulate yourself so you can make changes easily.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
|||"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
Use the sysprocesses table on the master database.
If you want, you could also try the application that I have developed called
DBMonitor. This will inform you of the users connected to each database, if
the users are actually running any commands, and what commands they are
running.
You can find a copy at http://dbmonitor.tripod.com
David Rowland
DBMonitor version 1.2 out now! http://dbmonitor.tripod.com
Email Alerts, logging, performance stats, process information!
Only $49.95
|||Thanks Uri and All for giving the Suggestions.
I think the the sysprocessess is the best option to go with and as Wayne
Snyder suggest I should be ready for 2005 also.
Thanks
Prabhat
> One of the many options is
> select hostname from master..sysprocesses
> where spid>50 and dbid=db_id('databasename')
List of Logged ON USERS
Hi All,
I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
the LIST of Users logged on to the SAME DB, so that I can Inform them to
Logout from the DB before I start the Process.
How Do I know the List of Users that have logged on to the DB - The List
should not include my login ( or ) a comment beside my login.
Thanks
PrabhatOne way would be to make a copy of the sp_who2 procedure and modify it to do
what you want. It wouldn't be difficult. Call it sp_who3 for example
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to kn
ow
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>|||Hi,
Apologies if this is a silly statement. You can use Enterprise Manager to
view a list of currently active connections. Go to Management | Current
Activity | Process Info
This will give you a list of current active sessions although it does
include things like the Checkpoint and Lazy Writer processes. As long as yo
u
can filter these out you should be able to see which users are connected and
which application they are using.
Hope this answers your question. If you already knew this then I apologise
for stating the obvious
Cheers,
IM
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to kn
ow
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>|||Prabhat
One of the many options is
select hostname from master..sysprocesses
where spid>50 and dbid=db_id('databasename')
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>|||Using Sysprocesses is the way to go... but it may change with SQL 2005, so
make sure you insulate yourself so you can make changes easily.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>|||"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
Use the sysprocesses table on the master database.
If you want, you could also try the application that I have developed called
DBMonitor. This will inform you of the users connected to each database, if
the users are actually running any commands, and what commands they are
running.
You can find a copy at http://dbmonitor.tripod.com
David Rowland
DBMonitor version 1.2 out now! http://dbmonitor.tripod.com
Email Alerts, logging, performance stats, process information!
Only $49.95|||Thanks Uri and All for giving the Suggestions.
I think the the sysprocessess is the best option to go with and as Wayne
Snyder suggest I should be ready for 2005 also.
Thanks
Prabhat
> One of the many options is
> select hostname from master..sysprocesses
> where spid>50 and dbid=db_id('databasename')
I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
the LIST of Users logged on to the SAME DB, so that I can Inform them to
Logout from the DB before I start the Process.
How Do I know the List of Users that have logged on to the DB - The List
should not include my login ( or ) a comment beside my login.
Thanks
PrabhatOne way would be to make a copy of the sp_who2 procedure and modify it to do
what you want. It wouldn't be difficult. Call it sp_who3 for example
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to kn
ow
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>|||Hi,
Apologies if this is a silly statement. You can use Enterprise Manager to
view a list of currently active connections. Go to Management | Current
Activity | Process Info
This will give you a list of current active sessions although it does
include things like the Checkpoint and Lazy Writer processes. As long as yo
u
can filter these out you should be able to see which users are connected and
which application they are using.
Hope this answers your question. If you already knew this then I apologise
for stating the obvious
Cheers,
IM
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to kn
ow
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>|||Prabhat
One of the many options is
select hostname from master..sysprocesses
where spid>50 and dbid=db_id('databasename')
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>|||Using Sysprocesses is the way to go... but it may change with SQL 2005, so
make sure you insulate yourself so you can make changes easily.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>|||"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
Use the sysprocesses table on the master database.
If you want, you could also try the application that I have developed called
DBMonitor. This will inform you of the users connected to each database, if
the users are actually running any commands, and what commands they are
running.
You can find a copy at http://dbmonitor.tripod.com
David Rowland
DBMonitor version 1.2 out now! http://dbmonitor.tripod.com
Email Alerts, logging, performance stats, process information!
Only $49.95|||Thanks Uri and All for giving the Suggestions.
I think the the sysprocessess is the best option to go with and as Wayne
Snyder suggest I should be ready for 2005 also.
Thanks
Prabhat
> One of the many options is
> select hostname from master..sysprocesses
> where spid>50 and dbid=db_id('databasename')
List of Logged ON USERS
Hi All,
I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
the LIST of Users logged on to the SAME DB, so that I can Inform them to
Logout from the DB before I start the Process.
How Do I know the List of Users that have logged on to the DB - The List
should not include my login ( or ) a comment beside my login.
Thanks
PrabhatOne way would be to make a copy of the sp_who2 procedure and modify it to do
what you want. It wouldn't be difficult. Call it sp_who3 for example
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>|||Hi,
Apologies if this is a silly statement. You can use Enterprise Manager to
view a list of currently active connections. Go to Management | Current
Activity | Process Info
This will give you a list of current active sessions although it does
include things like the Checkpoint and Lazy Writer processes. As long as you
can filter these out you should be able to see which users are connected and
which application they are using.
Hope this answers your question. If you already knew this then I apologise
for stating the obvious :)
Cheers,
IM
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>|||Prabhat
One of the many options is
select hostname from master..sysprocesses
where spid>50 and dbid=db_id('databasename')
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>|||Using Sysprocesses is the way to go... but it may change with SQL 2005, so
make sure you insulate yourself so you can make changes easily.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>|||"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
Use the sysprocesses table on the master database.
If you want, you could also try the application that I have developed called
DBMonitor. This will inform you of the users connected to each database, if
the users are actually running any commands, and what commands they are
running.
You can find a copy at http://dbmonitor.tripod.com
--
David Rowland
DBMonitor version 1.2 out now! http://dbmonitor.tripod.com
Email Alerts, logging, performance stats, process information!
Only $49.95|||Thanks Uri and All for giving the Suggestions.
I think the the sysprocessess is the best option to go with and as Wayne
Snyder suggest I should be ready for 2005 also.
Thanks
Prabhat
> One of the many options is
> select hostname from master..sysprocesses
> where spid>50 and dbid=db_id('databasename')
I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
the LIST of Users logged on to the SAME DB, so that I can Inform them to
Logout from the DB before I start the Process.
How Do I know the List of Users that have logged on to the DB - The List
should not include my login ( or ) a comment beside my login.
Thanks
PrabhatOne way would be to make a copy of the sp_who2 procedure and modify it to do
what you want. It wouldn't be difficult. Call it sp_who3 for example
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>|||Hi,
Apologies if this is a silly statement. You can use Enterprise Manager to
view a list of currently active connections. Go to Management | Current
Activity | Process Info
This will give you a list of current active sessions although it does
include things like the Checkpoint and Lazy Writer processes. As long as you
can filter these out you should be able to see which users are connected and
which application they are using.
Hope this answers your question. If you already knew this then I apologise
for stating the obvious :)
Cheers,
IM
"Prabhat" wrote:
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>
>|||Prabhat
One of the many options is
select hostname from master..sysprocesses
where spid>50 and dbid=db_id('databasename')
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>|||Using Sysprocesses is the way to go... but it may change with SQL 2005, so
make sure you insulate yourself so you can make changes easily.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
>|||"Prabhat" <not_a_mail@.hotmail.com> wrote in message
news:OtgrPnkdFHA.3376@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I use SQL Server 2000. Before I do some critical DB Updates I wanted to
> know
> the LIST of Users logged on to the SAME DB, so that I can Inform them to
> Logout from the DB before I start the Process.
> How Do I know the List of Users that have logged on to the DB - The List
> should not include my login ( or ) a comment beside my login.
> Thanks
> Prabhat
Use the sysprocesses table on the master database.
If you want, you could also try the application that I have developed called
DBMonitor. This will inform you of the users connected to each database, if
the users are actually running any commands, and what commands they are
running.
You can find a copy at http://dbmonitor.tripod.com
--
David Rowland
DBMonitor version 1.2 out now! http://dbmonitor.tripod.com
Email Alerts, logging, performance stats, process information!
Only $49.95|||Thanks Uri and All for giving the Suggestions.
I think the the sysprocessess is the best option to go with and as Wayne
Snyder suggest I should be ready for 2005 also.
Thanks
Prabhat
> One of the many options is
> select hostname from master..sysprocesses
> where spid>50 and dbid=db_id('databasename')
Subscribe to:
Posts (Atom)