Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to get detailed list of connections to database in sql server 2005?

Tags:

How to get detailed list of connections to database in sql server 2005?

like image 954
x2. Avatar asked Jan 11 '11 04:01

x2.

People also ask

How do I get a list of all SQL Server logins?

Answer: In SQL Server, there is a catalog view (ie: system view) called sys. sql_logins. You can run a query against this system view that returns all of the Logins that have been created in SQL Server as well as information about these Logins.

1 Answers

Use the system stored procedure sp_who2.

like image 159
Brian Ball Avatar answered Oct 16 '22 16:10

Brian Ball
Sign in to Comment

Related questions

How do I float a div to the center?
Disable clipboard prompt in Excel VBA on workbook close
Log4net not inserting into the database?
split string at index
Why does MSMQ think I'm on a workgroup computer?
Adding libxml2 in XCode
C++ convert integer to string at compile time
In R plot arima fitted model with the original series
How to get text between two characters?
Get Attribute model by attribute_code in Magento
ListView top highlight on scrolling
Does unicode or HTML have a vertical double guillemet (chevron)?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!