Re: Name change, can't find origin of error
- From: "Sethu Srinivasan [MSFT]" <sethu.srinivasan@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 6 Sep 2006 10:35:45 -0700
1) You could run SQL Profiler to trace all queries sent to SQL Server when you perform this action through web app. You can take a look at the captured batches to see if any of those queries refer to the old table. There could be ad-hoc queries, views, UDFs, stored procs that may refer to the old table, you could take a look at the source code for those SPs, UDFs( sp_helptext on T-SQL stored procs). If there were any CLR stored procs / UDF's you need to take a look at the source code for those .NET classes to see if there were any ad-hoc calls to the old table
2) You can also set a break point in ASP.NET code
ST2allowed.RetrieveData(" ... and step into the code to analyze the rootcause of this exception
--
Thanks
Sethu Srinivasan, Software Design Engineer, SQL Server Manageability
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Reeve" <jamesn@xxxxxxxxxxx> wrote in message news:1156946765.373052.150810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I've recently made a name change on a few database tables. I thought I
got all the name changes done in the front end reference. However,
this one eludes me. I've checked all the classes listed in the error
trace. I've done full text searches across all the documents of the
project and I still can't find a reference to 'ACAllowedMarketCaps'
anywhere.
http://i13.photobucket.com/albums/a291/Reeve04/UnknownError.jpg
Are there any other techniques that people have used to troubleshoot a
problem like this? Or am I missing something in the info displayed on
the error page? Thanks in advance
.
- Prev by Date: Re: copy database error 12291 and 208
- Next by Date: Re: database mail...can't connect to mailserver
- Previous by thread: Re: OSQL Input File Size
- Next by thread: Re: Query Analyzer in Sql Server 2005
- Index(es):
Relevant Pages
|
