test ASP with SQL Profiler

Last Post 17 Jan 2008 01:45 AM by SQLUSA. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mabbus
New Member
New Member

--
27 Jun 2007 11:46 PM
Hi,

I am using SQL 2000 and have a stored procedure that loops through a of range mobile numbers checking to see if they exist before insert, the procedure works fine without the check;

IF NOT EXISTS ( SELECT 1
FROM wbMcd
WHERE TELNUMBER = @NUMRANGE )

but nothing seems to happen with it in place. I asked via another forum if I had missed something in my procedure but somebody said it looked fine and to run the ASP page through SQL Profiler. I am fairly new to SQL and although I have used QA I have never used SQL Profiler.

When I went in SQL Profiler I didn't (don't) have a clue where to start, if somebody could either walk me through how to check an ASP pages call to an SP or point me to an article which explains how to do it I would be greatful.

Many thanks
SQLUSA
New Member
New Member

--
17 Jan 2008 01:45 AM
Is the stored procedure working from Query Analyzer? Check with your DBA.

Your DBA should be able to do SQL Profiler as well, although that may not be necessary.

Kalman Toth - Database, Data Warehouse & Business Intelligence Architect
SQLUSA: http://www.sqlusa.com/order2005highperformance/ The Best SQL Server 2005 Training in the World!
You are not authorized to post a reply.

Acceptable Use Policy