473,656 Members | 2,983 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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
Jul 21 '05 #1
2 2045
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" <iw***@theagenc y.com> wrote in message
news:4b******** *************** *****@phx.gbl.. .
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

Jul 21 '05 #2
I am not sure. Is there any way I can tell from
Enterprise Manager?

Thanks,
Joe
-----Original Message-----
You DID install debugging support onthe SQL Server, right?
This just works with expanded SQL Servers, which you should not do onproduction servers.

--
Regards

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

"Joe Sullivan" <iw***@theagenc y.com> wrote in message
news:4b******* *************** ******@phx.gbl. ..
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

.

Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

18
10267
by: Robin Lawrie | last post by:
Hi again, another problem! I've moved from an Access database to SQL server and am now having trouble inserting dates and times into seperate fields. I'm using ASP and the code below to get the date and time, but my script is erroring. '-- Get login date and time cmdLoginDate = Date() cmdLoginTime = Time()
0
3221
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...
5
1497
by: Bill | last post by:
1. I find that debugging does not work if the JavaScript you wish to debug is included in your program via src="blah". All of my programs use this because I have many common scripts that are used throughout my application. It also gives a very limited amount of security to prying eyes. 2. If I extract the portion of the JavaScript I wish to debug and put it locally within the aspx file, the debugging works. 3. If I try to debug both my...
2
270
by: Joe Sullivan | last post by:
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,
6
2499
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...
0
958
by: Arpan | last post by:
Suppose I have the following DataList code: <script runat="server"> Sub Page_Load(ByVal obj As Object, ByVal ea As EventArgs) ................... ................... ................... dlUsers.DataBind() End Sub </script>
5
2798
by: rn5a | last post by:
Can someone please suggest me a text editor especially for DEBUGGING ASP scripts apart from Microsoft Visual Interdev? I tried using Visual Interdev & created a project but Interdev generates some error related to FrontPage extensions. I couldn't exactly understand the error. I tried to create the project in C: \Inetpub\wwwroot. If I just open a ASP file (by navigating to the File-->Open File... menu), then Interdev doesn't give the...
3
2754
by: Rick | last post by:
We have a web site that was built as an ASP.Net Web Site, I am unable to remote debug, when build ing the web site there is not a dll or PDB file generated. I can debug on my local machine but unable to attach to the process when running from the web server. Can someone tell me how to remote debug an ASP.Net Website that does not genate a dll or PDB file? Thanks in advance! Rick
4
12689
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...
0
8380
marktang
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, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8296
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,...
0
8710
jinu1996
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...
0
8598
tracyyun
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...
1
6162
isladogs
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...
0
5627
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4150
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...
0
4299
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1598
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.