Debugging MS SQL Server procedured within Visual Studios .NET

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Joe Sullivan
    #1

    Debugging MS SQL Server procedured within Visual Studios .NET

    I have noticed that Visual Studios .NET has a debug mode
    for SQL statements, but I can't seem to get it to work
    with MS SQL Server. I can't seem to pull up my stored
    procedures from the Server Explorer to set breakpoints.
    Does anyone know if this can be done? I can open my
    stored procedures from an MS Access project... it seems
    odd to me that I have greater debugging tools in Access
    than in VS.

    Thanks,
    Joe
    Tags: None
    • Thomas Tomicek [MVP]
      #2
      Re: Debugging MS SQL Server procedured within Visual Studios .NET

      You DID install debugging support onthe SQL Server, right?

      This just works with expanded SQL Servers, which you should not do on
      production servers.

      --
      Regards

      Thomas Tomiczek
      THONA Software & Consulting Ltd.
      (Microsoft MVP C#/.NET)

      "Joe Sullivan" <iwork@theagenc y.com> wrote in message
      news:4bf501c376 3e$1ab62360$a40 1280a@phx.gbl.. .[color=blue]
      > I have noticed that Visual Studios .NET has a debug mode
      > for SQL statements, but I can't seem to get it to work
      > with MS SQL Server. I can't seem to pull up my stored
      > procedures from the Server Explorer to set breakpoints.
      > Does anyone know if this can be done? I can open my
      > stored procedures from an MS Access project... it seems
      > odd to me that I have greater debugging tools in Access
      > than in VS.
      >
      > Thanks,
      > Joe[/color]


        Comment

        • Joe Sullivan
          #3
          Re: Debugging MS SQL Server procedured within Visual Studios .NET

          I am not sure. Is there any way I can tell from
          Enterprise Manager?

          Thanks,
          Joe
          [color=blue]
          >-----Original Message-----
          >You DID install debugging support onthe SQL Server,[/color]
          right?[color=blue]
          >
          >This just works with expanded SQL Servers, which you[/color]
          should not do on[color=blue]
          >production servers.
          >
          >--
          >Regards
          >
          >Thomas Tomiczek
          >THONA Software & Consulting Ltd.
          >(Microsoft MVP C#/.NET)
          >
          >"Joe Sullivan" <iwork@theagenc y.com> wrote in message
          >news:4bf501c37 63e$1ab62360$a4 01280a@phx.gbl. ..[color=green]
          >> I have noticed that Visual Studios .NET has a debug[/color][/color]
          mode[color=blue][color=green]
          >> for SQL statements, but I can't seem to get it to work
          >> with MS SQL Server. I can't seem to pull up my stored
          >> procedures from the Server Explorer to set breakpoints.
          >> Does anyone know if this can be done? I can open my
          >> stored procedures from an MS Access project... it seems
          >> odd to me that I have greater debugging tools in Access
          >> than in VS.
          >>
          >> Thanks,
          >> Joe[/color]
          >
          >
          >.
          >[/color]

            Comment

            Previous template Next
            Working...