RE: cannot delete a record in sql server 2005 through asp program
- From: c676228 <betty@xxxxxxxxxxxxxxxx>
- Date: Wed, 10 Jun 2009 20:24:29 -0700
Hi all,
Thanks for your input. Mark helped me to find the issue.
Using trace script he provided and trace file created by the script. I was
able to locate the issue.
It's really my fault. I include a file to point to test database I want to
run against and it has the stored procedure. But somehow another include file
which points to the production database was included unintentionally later
on. It caused all the issues since the program somehow is running against
production database which doesn't have the stored procedure I am working on.
Sincerely
--
Betty
"Mark Han[MSFT]" wrote:
Hi Betty.
Thank you for using Microsoft MSDN Managed Newsgroup. This is Mark Han,
again. I am glad to work with you on this issue.
From your description, I understand that you fail to delete a record in the
SQL Server database by the asp application. If I have misunderstood, please
let me know.
To make the issue clear, i would like to explain my understanding and
troubleshooting logic for you.
1 Based on your description, since the record is able to be deleted by the
same user and same command which you use in asp application, the issue
might not a permission problem
2 to furhter narrow down the issue, firstly we need to verify if the
request(delete) has been applied to the SQL Server by capture the SQL
Server Profiler Trace
if he request(delete) has been applied to the SQL Server, we need to check
if the command is blocked
if he request(delete) is not able to be applied to the SQL Server, we need
to check the application.
in order to help you to resolve the issue, I have made a templete of the
SQl Server Profiler trace. if it is convenient to you, please send me an
email so that I can send the templete to you. My email address is
v-fathan@xxxxxxxxxxxxxxxxxxxx (please remove online)
If there is anything unclear, please do not hesitate to let me know.
I look forward to your reply
Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================
- Follow-Ups:
- RE: cannot delete a record in sql server 2005 through asp program
- From: Mark Han[MSFT]
- RE: cannot delete a record in sql server 2005 through asp program
- References:
- cannot delete a record in sql server 2005 through asp program
- From: c676228
- RE: cannot delete a record in sql server 2005 through asp program
- From: Mark Han[MSFT]
- cannot delete a record in sql server 2005 through asp program
- Prev by Date: Re: go to next iteration in a cursor
- Next by Date: Re: Run multiple scripts in a single command
- Previous by thread: RE: cannot delete a record in sql server 2005 through asp program
- Next by thread: RE: cannot delete a record in sql server 2005 through asp program
- Index(es):
Relevant Pages
|
