I have installed Microsoft SQL Server 2008 R2 express edition.
It got installed to C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\....
I am able to open SQL serve rmanagement studio and able to do my transactions with my databases
but when i am trying to run the sqlservr.exe from the path C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn , i am getting error popup.
due to this i am not able to debug the extended stored procedures . I am providing the procedure to debug an extended stored procedure
the procedure we followed to debug an extended stored procedure
Make a debug build of the extended stored procedure DLL by using Microsoft Visual C. Make sure to generate the .pdb file.After you correctly build the DLL, copy it to the C:\Mssql\Binn folder. The DLL that SQL Server is loading and the .pdb file must be synchronized to properly handle breakpoints.Register the extended sto ...
Go to the complete details ...