Collectives™ on Stack Overflow
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about Collectives
Teams
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Learn more about Teams
We're in the process of converting to
SQL Server
from
MySQL
. I'm trying to figure out why a call to
sqsh
isn't returning and I suspect that there's some lock I don't know about.
How do you find out what's going on (preferably via the database connection)?
SQL Server includes a few undocumented procs.
sp_who2
lists all current processes connected to a SQL Server. It's located in the
master
database.
USE master;
EXEC sp_who2;
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
