Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 Unable to debug CLR stored procedure

Author  Topic 

meetsimpy
Starting Member

1 Post

Posted - 2008-07-10 : 03:29:05
Hi
I have created a clr sql stored proc using class library. It executes well but I want to debug it.I do the following steps
Go to the Debug --> Attach to Process menu item and select "sqlservr.exe" as the process .
No "Attach to" includes T-SQL Code and Managed Code.
Click on Attach,
After clicking on attach button,the output window looks like -

'sqlservr.exe': Loaded 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\ntdll.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\kernel32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700\msvcr80.dll', Symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\msvcrt.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\WinSxS\x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.762_x-ww_6b128700\msvcp80.dll', Symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\advapi32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\rpcrt4.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\user32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\gdi32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\crypt32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\msasn1.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\secur32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\mswsock.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\ws2_32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\ws2help.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\userenv.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\opends60.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\netapi32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\shell32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\shlwapi.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2180_x-ww_a84f1ff9\comctl32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\comctl32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\psapi.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\Program Files\Microsoft SQL Server\90\Shared\instapi.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\Resources\1033\sqlevn70.rll', Binary was not built with debug information.

'sqlservr.exe': Loaded 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlos.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\rsaenh.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\authz.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\mscoree.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\ole32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\msv1_0.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\iphlpapi.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\kerberos.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\cryptdll.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\schannel.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\security.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\version.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\ntmarta.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\wldap32.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\samlib.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\ntdsapi.dll', No symbols loaded.

'sqlservr.exe': Loaded 'C:\WINDOWS\system32\dnsapi.dll', No symbols loaded.

The thread 'Win32 Thread' (0xf58) has exited with code 0 (0x0).

Now go to SQL Server Management Studio and execute Stored procedure.
But I am able to debug it because breake point does not hit.

Please reply me
Thanks In advance
Simpy Shukla
   

- Advertisement -