debugger doesn't stop at breakpoint while debugging SQLCLR Procedure

• ramsatish

  Old Hand

  Points: 380

  More actions

  January 20, 2009 at 8:28 am

  #205556

  Hi,

  When I try to debug this SQL CLR Stored Procedure from Visual Studio 2005, I am getting the output in Output window along with debug information but it is not stopping at breakpoint.

  Output window says ‘No symbols loaded’.

  I followed the procedure given in the below link to create a stored procedure.

  http://msdn.microsoft.com/en-us/library/ms165051(VS.80).aspx

  I am getting the output below when I execute the stored procedure

  'sqlservr.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\mscorlib\2.0.0.0__b77a5c561934e089\mscorlib.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

  'sqlservr.exe' (Managed): Loaded 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SqlAccess.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

  'sqlservr.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Data\2.0.0.0__b77a5c561934e089\System.Data.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

  'sqlservr.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System\2.0.0.0__b77a5c561934e089\System.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

  'sqlservr.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_32\System.Transactions\2.0.0.0__b77a5c561934e089\System.Transactions.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

  'sqlservr.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Security\2.0.0.0__b03f5f7f11d50a3a\System.Security.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

  'sqlservr.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Xml\2.0.0.0__b77a5c561934e089\System.Xml.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

  'sqlservr.exe' (Managed): Loaded 'CSharpPart1', No symbols loaded.

  'sqlservr.exe' (Managed): Loaded 'C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\2.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll', Skipped loading symbols. Module is optimized and the debugger option 'Just My Code' is enabled.

  'sqlservr.exe' (Managed): Loaded 'ServicePack', No symbols loaded.

  Auto-attach to process '[1964] sqlservr.exe' on machine 'xyz-5' succeeded.

  The thread 'xyz-5 [70]' (0x15b4) has exited with code 0 (0x0).

  Hello World from SQLCLR !!

  No rows affected.

  (0 row(s) returned)

  Finished running sp_executesql.

  The program '[1964] sqlservr.exe: Managed' has exited with code 259 (0x103).

  The program '[1964] [SQL] xyz-5: xyz-5' has exited with code 0 (0x0).

  Thanks in advance

  Regards,

  Sriram Satish