>>>>Hi,
>>>>
>>>>I've been working on a local report and created a stored procedure which accepts a parameter and pulls back the relevant records. I have configured my report viewer on a form and load the data up like this:
>>>>
>>>>
>>>>invoicesReportTableAdapter.Fill(dataset.InvoicesSelectByManifestNumber, this.manifestNumber);
>>>>
>>>>Prior to making some changes to the underlying stored procedure everything was working great. I then realized I had pulled out an incorrect field and missed two others that I needed for the report. I changed the SP and reconfigured the xsd by editing it and choosing to configure it again. But whenever that line of code runs, it takes a few seconds and then my application shuts down before it returns. No error message. Any idea what this could be or how to debug it?
>>>
>>>Stop the debugger just before this line.
>>>Run SQL Profiler and then step down in debugger, see what is sent to SQL Server.
>>>You can copy and run this code with SSMS.
>>
>>Hmmm, I can't find SQL Profiler. Is that not part of SQL Server Express 2008 R2?
>
>Nope,
>Profiler doesn't exists in Express editions :o(
>Don't you have another edition of SQL Server?
>Developer, Standard...?
:) I've run the profiler, but have no idea of what I'm looking at so I need to do some research into how to interpret it. Any pointers to a good description?