473,508 Members | 2,356 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Hitting Sql Server Stored Procedure Breakpoint from ASP.NET app

Hello,
I am not able to stop at a stored procedure breakpoint in SQL Server from an
ASP.NET application unless I specify a username and password in my connection
string instead of using integrated security = SSPI. I can't figure out how to
give the ASP.NET user the ability to debug stored procedures. I tried running
sp_sdidebug 'legacy_on' from my ASP.NET app so it would run undere the
ASP.NET user, but that didn't help. Still can only do it by specifying a
different user in DB connection string. Is it possible to give ASP.NET user
debugging rights in SQL Server?
Thanks

Nov 19 '05 #1
0 854

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

Similar topics

1
1802
by: David C. Allen | last post by:
I am trying to debug an SQL Server Stored Procedure form VS.NET 2003. I have a break point set in the SP code but it is not being hit. When I hold the pointer over the line it says that it will not...
0
2630
by: Amber | last post by:
Stored procedures are faster and more efficient than in-line SQL statements. In this article we will look at two SQL Server stored procedures; one using an input parameter and one not, and see how...
3
2241
by: Allen Smith | last post by:
Is it possible to debug a stored procedure in SQL Server 2000 from VS 2003 ? Thanks, Smith
5
2071
by: DCC-700 | last post by:
I am using ASP.Net with VB on the 1.1 Framework running on Win XP Pro. I am trying to gauge the time it takes to sort a datagrid using different code sets. But when I am debugging the page there...
1
1278
by: scott | last post by:
..net 2003 - debug stored procedure ok on 2k - but ? on XP at breakpoint. Hi, In VS.net 2003 i set a breakpoint on a stored procedure and attempt to step into stored procedure to debug. All i...
2
6926
by: Jobs | last post by:
Download the JAVA , .NET and SQL Server interview with answers Download the JAVA , .NET and SQL Server interview sheet and rate yourself. This will help you judge yourself are you really worth of...
1
2304
by: Brad Pears | last post by:
I have a vb.net 2005 app that calls strored procedures. I am having difficulties with one of my stored procs and thought I'd try to debug it from my vb app. I went to the server explorer page,...
2
9021
by: smileprince00 | last post by:
what is meant by break point in the sql server studio.. what is the purpose of it..let me know clearly........................ and one more thing is i am hearing a word regularly while...
0
7115
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...
0
7321
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7489
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...
1
5047
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...
0
4705
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...
0
3191
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...
0
3179
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1547
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
762
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.