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

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


Show quoteHide quote

SQL Server 2005 Activity Monitor doesn't show connections from Windows 98 clients
differnt execution plans for same query
Import Data succeeds but doesn't copy data?
SQL Server 2005 Management Studio vs. 2000 Enterprise Manager/Query Analyzer
SIMPLE command to convert string to number? Not CAST or CONVERT.