Friday, March 23, 2012

I can't debug my SQL Server project

I'm coding a TVF in C# and the debugger doesn't stop at all. It used to work when I was coding scalar functions, but it stop working since I removed my assembly from the DB and register it manually to test my SQL scripts. I removed the assembly again from my DB and re-deployed it with VS.2005 hoping that will fix it, but it didn't work. Right now I can't debug.

Have anybody had a problem like this before? Any help will be appreciated.

Do you use your TVF in default test script in your VS project?|||Yes. The weird thing is that the debugger was working before, and I debugged scalar functions. But since I deployed the assembly manually and then removed it to deployed it from VS.2005, somehow the debugger stopped working.|||Check content of output window, you could find error messages here.|||

Got it. There was a problem with a commented section in query.

Thank you.

sql

No comments:

Post a Comment