Re: Debugging stored procedure in visual studio?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: CMA (cmallawaarachchi_at_textcentric.lk)
Date: 07/28/04 

Date: Wed, 28 Jul 2004 16:14:59 +0600

I just used "print 'line 5 executed'" kind of messages between some lines.
so I can get an idea, where it is failing...

OR if u used try.. catch.. for the calling code segment, u'll get the
descriptive message from the error.

regards,
CMA

"bredal Jensen" <bred.jen@mimosa.com> wrote in message
news:O4fzUEHdEHA.3916@TK2MSFTNGP11.phx.gbl...
>
>
> I have a stored procedure wich is inoked through my asp.net code.
>
> The stored procedure failed and it quit extensive.
>
> I 'm therefore wondering if there is a way to step through the stored
> procedure
> from visual studio.net or maybe from sql server 200 itself?
>
>
> Thanks in advance
>
>

Relevant Pages

  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)
  • Re: Accessing FoxPro Free Table
    ... which the SQL Server service is running. ... account, ... > If you are creating a stored procedure and you want> to make sure that the procedure definition cannot be> viewed by other users, you can use the WITH ENCRYPTION> clause. ... The procedure definition is then stored in an> unreadable form. ...
    (microsoft.public.data.odbc)
  • Re: Adding date to parameter
    ... SqlClient provider which is specifically written for SQL Server. ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... I made the assumption that the stored procedure went by the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Problem with the Legacy ASP files and the Sql Server Express
    ... table, if another inserting occurs at the nearly exactly the same moment, ... SQL Server will pass it a default value. ... assume that you do have a connection that can reach SQL Server Express. ... unless your stored procedure has some thing that only works ...
    (microsoft.public.dotnet.framework.aspnet)
  • Stored procedure does not complete until result set is retrieved from ODBC
    ... I have a SQL Server Stored procedure that I am executing via ODBC. ... -- Start Code without cursor ...
    (microsoft.public.sqlserver.odbc)