<div>
We do have SP2. How can I find out wha tthe db compt level is set to? <br />
<br />
I will also try your query. Thank you.<br />
<br />

</div>


We do have SP2. How can I find out wha tthe db compt level is set to?

I will also try your query. Thank you.



<div>
right click the db, go to properties, then options...<br />
<br />
you're welcome.
</div>


right click the db, go to properties, then options...

you're welcome.

<div>
Awesome! Thank you so much for your help. This is out of the scope of this question, but what's the difference between using JOIN and APPLY in a SQL Statement...it seems as though they accomplish similiar tasks. 
</div>


Awesome! Thank you so much for your help. This is out of the scope of this question, but what's the difference between using JOIN and APPLY in a SQL Statement...it seems as though they accomplish similiar tasks.

<div>
No problem....the APPLY is new to 2005 and is used to pass values from a table or view as parameters into a table-valued function (which you can't do w/ a JOIN operator)
</div>


No problem....the APPLY is new to 2005 and is used to pass values from a table or view as parameters into a table-valued function (which you can't do w/ a JOIN operator)

<div>
Excellent...thanks again for your help and patience. 
</div>


Excellent...thanks again for your help and patience.

<div>
Thank you for all of your help.
</div>


<div>
<div class="content wysiwyg-content">
I'm trying to troubleshoot a SQL issue. I know it's a blocking issue in SQL 2005...so I go do the following:<br />
<br />
1) sp_who2<br />
2) I find the spid that is causing the block and do an DBCC Inputbuffer(spid)<br />
<br />
The issue with this is that it only displays 256 characters. So, I'll only see part of a SQL Query and it truncates. Is there another tool or some kind of parameter I could put on this command so that the results aren't truncated? <br />
<br />
Thanks
</div>
</div>


I'm trying to troubleshoot a SQL issue. I know it's a blocking issue in SQL 2005...so I go do the following:

1) sp_who2
2) I find the spid that is causing the block and do an DBCC Inputbuffer(spid)

The issue with this is that it only displays 256 characters. So, I'll only see part of a SQL Query and it truncates. Is there another tool or some kind of parameter I could put on this command so that the results aren't truncated? 

Thanks

DBCC Inputbuffer

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.