>>>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...?