How do I find what is the associated query that is being executed if I have the SPID. Trying to figure out what query is being associated sinc开发者_StackOverflow社区e the process seems to be hung.--F
I just tried to make a simple schema change to a table in a SQL Server database (by using the Design tool in SMSS). Whenever I tried to save the change, it kept timing out. I wondered whether this was
Can a SPID be used by two connections, while both connections are open? If a connection is returned to a connection pool, will开发者_StackOverflow it hold on to the SPID?
Is it possible to have an ODBC connection and an ADO connection share the same underlying SQL Server connection, so that both are using the same SPID?