Viewing commands issues via ASP.NET 1

[kholladay]

I have several ASP.NET aspx pages that I use to execute stored procedures but one of them seems to be broken. Is there a way for me to view the traffic coming into SQL so I can see exactly what command was received and what the result was?

Kyle Holladay / IPOfficeHelp.com
ACSS/ACIS/APSS Avaya SME Communications
APDS Avaya Data
MCP/MCTS Exchange 2007/2010
Adtran ATSA, Aruba ACMA

"Thinking is the hardest work there is, which is the probable reason why so few engage in it." - Henry Ford

 

[kholladay]

After a bit more reading I think I need something called a profiler but it may not be available to me as I am using 2008 R2 Express.

Kyle Holladay / IPOfficeHelp.com
ACSS/ACIS/APSS Avaya SME Communications
APDS Avaya Data
MCP/MCTS Exchange 2007/2010
Adtran ATSA, Aruba ACMA

"Thinking is the hardest work there is, which is the probable reason why so few engage in it." - Henry Ford

 

[markros]

A couple of options:

http://www.mssqltips.com/tip.asp?tip=1035

http://sqlprofiler.googlepages.com/

recommended by:

http://blogs.microsoft.co.il/blogs/adlaim/archive/2009/04/13/sqlserver-express-2008-profiler.aspx

PluralSight Learning Library

 

[kholladay]

Option 2 worked like a charm! I knew it wasn't query I just needed to see what was getting there so I could rule it out.

Thank you very much!

Kyle Holladay / IPOfficeHelp.com
ACSS/ACIS/APSS Avaya SME Communications
APDS Avaya Data
MCP/MCTS Exchange 2007/2010
Adtran ATSA, Aruba ACMA

"Thinking is the hardest work there is, which is the probable reason why so few engage in it." - Henry Ford