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 stepsGo 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 advanceSimpy Shukla |
|