I'm trying to troubleshoot a SQL issue. I know it's a blocking issue in SQL 2005...so I go do the following:
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?