hey all,
is there possibly a way to step into a stored proc while debugging in asp.net?
thanks,
rodchar
2  1276 
Hope I'm not just rehashing something you've already looked over, but...
From http://www.expresscomputeronline.com...chspace1.shtml :
Debugging a stored procedure
Here’s how you debug a stored procedure:
1. Right click on the SP in the Server explorer and choose “Step into ….” OR
2. If the SP is already being edited, right click in the editor and choose
“Step into …” option
3. You can view the locals immediately.
4. A yellow arrow appears on the left side of the next executable statement.
5. To continue further you choose Step into (F11) or Step over (F10) from
the Debug menu.
6. To add a variable to watch, drag it from the editor onto the watch window.
7. You can change the values in watch window, at runtime.
8. You can also set breakpoints before or during debugging.
"rodchar" wrote:
hey all,
is there possibly a way to step into a stored proc while debugging in asp.net?
thanks,
rodchar
Does it matter if i'm running msde because i'm getting the following error:
---------------------------
Microsoft Development Environment
---------------------------
Cannot debug stored procedures because the SQL Server database is not setup
correctly or user does not have permission to execute master.sp_sdide bug. Run
SQL Server setup or contact database administrator.
---------------------------
OK Help
---------------------------
"Keith" wrote:
Hope I'm not just rehashing something you've already looked over, but...
From http://www.expresscomputeronline.com...chspace1.shtml :
Debugging a stored procedure
Here’s how you debug a stored procedure:
1. Right click on the SP in the Server explorer and choose “Step into ….” OR
2. If the SP is already being edited, right click in the editor and choose
“Step into …” option
3. You can view the locals immediately.
4. A yellow arrow appears on the left side of the next executable statement.
5. To continue further you choose Step into (F11) or Step over (F10) from
the Debug menu.
6. To add a variable to watch, drag it from the editor onto the watch window.
7. You can change the values in watch window, at runtime.
8. You can also set breakpoints before or during debugging.
"rodchar" wrote:
hey all,
is there possibly a way to step into a stored proc while debugging in asp.net?
thanks,
rodchar
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: ZMan |
last post by:
Scenario:
This is about debugging server side scripts that make calls to
middle-tier business DLLs. The server side scripts are legacy ASP 3.0
pages, and the DLLs are managed DLLs converted/developed with VB.NET.
What I want from debugging is to be able to step into the methods in
the DLLs called from ASP scripts using Visual Studio .NET.
Background:
For typical script debugging issues, you can read and follow the two
documents on...
|
by: Serdar Kalayc |
last post by:
Hi everybody,
My problem seems a bit clich but I could not work around.
Well I read lots of MSDN papers and discussions, but my problem is a bit
different from them. When I tried to run the project in debug mode (by
hitting F5) it gives an error message
"Error while trying to run project: Unable to start debugging on the web
server.
|
by: Andy Fish |
last post by:
Hi,
Using VS.NET 2003, when I use 'F5' to start debugging my web app, it
obviously attaches the IDE to IIS for server debugging. However, it also
seems to put IE into some kind of debugging mode (for javascript debugging)
This causes IE to consume loads of CPU if the page is very large.
Is there any way to have debugging of server side code but leave IE in
"normal" mode?
|
by: Alex Clark |
last post by:
Hi All,
My system:
WinXP Pro, VS.NET 2003, SQL Server Personal Edition.
I'm having problems with my old favourite demon, SQL Debugging from within
VS.NET. I have to say I've found this particular feature to be one of the
most useful and (sadly) unreliable/fragile features in VS.NET, it seems the
slightest thing will break it.
|
by: Velvet |
last post by:
Can someone tell me to what process I need to attach to be able to step
through my classic ASP code in VS.net 2003. I'm working on an XP box with
IIS installed. I also have VS.net 2005 (The final, never installed beta)
installed on this box if it makes a difference (I did not install VS
Development Web Server as I'm already using the XP web server).
I've seen that I need to attach to the native IIS engine, but I don't know
what it's...
| | |
by: KevinGPO |
last post by:
I am currently developing a website in ASP (VBScript) using MS Visual C#.NET
IDE. I just create a new "ASP.NET Web Application" and point to my local
webserver (IIS) of my website address. Then I just go through each
file/folder and right-click, selecting "Include in project". The IDE is nice
in that it checks, verifies id tags, etc. What am wondering is whether it's
possible to debug my ASP website using the MS Visual Studio.NET's...
|
by: phnimx |
last post by:
Hi ,
We have developed a number of plug-in .NET Library Components that we
typically deploy with our various applications by installing them into the
GAC.
Each of the applications contains an app.config file referencing arbitrary
versions of the plug-in components they wish to consume.
Here's the problem:
Assuming I have installed any one of our application software,
|
by: =?Utf-8?B?Z2FkeWE=?= |
last post by:
I can't get to debug on my local IIS using VStudio.net 2005 Prof. I can on
the development server. I get the msg 'the server does not support debugging
for asp.net...'
I have done the following as in 'How to: Enable Debugging for ASP.NET
Applications'
Under Debuggers ASP.NET box is selected
in web.config set compilation debug="true"
in virtual directory:
|
by: jwwicks |
last post by:
C/C++ Programs and Debugging in Linux
This tutorial will give you a basic idea how to debug a program in Linux using GDB. As you are aware Visual Studio doesnt run on Linux so you have to use some of the tools provided on the command-line. If you hate the command line tools, get over it since youre bound to be using them at some point in your career. All commands in Linux ARE case sensitive so capital letters are different from lowercase...
|
by: =?Utf-8?B?TWlrZSBHYWxl?= |
last post by:
VS 2008 initially didn't debug classic ASP.
SP1 fixes this in some ways. You can debug if you select the debug option
to "Start Without Debugging, then either attach the debugger manually or
place a stop directive in the code which ends up doing the same thing.
The problem with this is that you can't debug browser side Javascript in the
same debug run.
You get a "The breakpoint will not currently be hit. The document is not
loaded." if...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look !
Part I. Meaning of...
| | |
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
