.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Issues with SQL CLR deployment and debugging

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server

We're having 3 issues.  I've posted a ticket with Microsoft phone support, but am posting here as well in case I can shortcut that support process, and so it will be documented for other users.  I'm running Windows XP, Visual Studio 2008 and Visual Studio 2010, and SQL Server 2008 with Management Studio version 10.0.2531.0:

1) In Visual Studio 2010 on my machine AND my coworkers' machines: If we try to deploy any SQL CLR project to a large database, the deploy hangs Visual Studio for a long time, and eventually returns but fails to deploy the objects to the database.  No error message is thrown.

2) In Visual Studio 2010 on my machine AND my coworkers' machines: if we create a new SQL Server Project, add a new User Defined Function that simply returns a scalar value, put a breakpoint in that function, attach to the sqlservr.exe process from Visual Studio 2010, and then run the function from SQL Server Management Studio, the breakpoint is not hit and the function hangs until the debugger is stopped, at which point SQL Server Management Studio indicates that the query was cancelled.  We can work around this by debugging in Visual Studio 2008, but it's a hassle (i.e. start a different project debugging in Visual Studio 2008.  Open the files you want to debug in the same Visual Studio 2008 instance (even though they were created in

View Complete Post

More Related Resource Links

Debugging ASHX after deployment



I'm finished with a part of my ASHX handler and need to test it against the software that'll be calling it using HTTP POST. The software required an https url so I created an internally hosted site in IIS and published the project there. 

Question now is how do I do any debugging on the script to see what data is coming out of it before the data goes back into the software that's calling it? Do I set something on the project itself to be able to step into the published DLL? 

setup/deployment issues


I have built an installation (MSI) for a project I'm designing. I'm using Visual Studio 2008.  Mostly it works fine; however, I have two issues:

1) for some reason, it insists on installing .NET 3.5, even though all the projects within the install use .NET 2.0. Is this because the installer requires 3.5? If so, I guess I can live with it.

2) I want one of the programs to run on startup, and actually, it does. I assigned the Primary Output of the program to the User's startup folder. HOwever, the install also copies the .config file to startup; so it launches it notepad, leaving the user looking at a config file they obviously shouldn't be seeing.


Any thoughts? Thanks in advance... 

Debugging Issues in Windos 7 & Visual Studio 2008

I have Strange issue.I have Windows 7 and Visual Studio 2008.When I try to debug a web application by inserting BreakPoint. It will go fine for few seconds or couple of  minutesAfter that the debugging stops automatically. But were else if did not insert Break point in the application the webpage is alright. (I can see debugger still running)Does any one have come across the same issue please shed me some light.Thanking you in advanceNathanI had the same issue in the XP after installing IE 8. The below line solved the issue but this wont work for windows 7Add a DWORD value called TabProcGrowth with a value of 0

Debugging Issues.



 So I am debugging a method, and going into debug mode one of the things I use are hovering over vaiables and Watch to see the variable values at some point in time. However, now I seem to be getting nothing when I hover over and the watch shows:

the name 'textInCommand' does not exist in the current context

 But, and here's the part I dont understand, it compiled correctly and although it isnt showing me the variable values, when I add this value to another (ie += on a string) it adds correctly.


Any Ideas?



Issues with SQL CLR debugging using VS2010 and SQL 2008 R2

I upgraded a VS 2008 SQL CLR project, which worked perfectly, to VS 2010 SP1.  However, I did not have to debug the CLR routines until today.  Now, whenever I attempt to debug a change to my code, the deployment succeeds (the new function is listed in the database), but the debugging never occurs because although it says that is successfully attached (“Auto-attach to process '[1696] [SQL] stx3-desktopx64' on machine 'stx3-desktopx64' succeeded”).  It also says that it was “Canceled by user”, which it certainly was not.  I have also tried simply debugging on a different machine, which had NO changes made at all to the project, and it generates exactly the same messages.  I have also changed the target from Any CPU to x86 to x64 to no avail.  Both test machines use a local SQL instance that is x64, as is the version of Win 7.  I read one article that suggested manually deploying the routine would help, but it changes nothing.  Every debug attempt results in the same messages after 20-30 seconds of waiting.  On VS 2008, t

VB2008 Express and SQL Server CE 3.5 private deployment issues


Windows Forms application developed with VB 2008 Express.
Using private deployment as described in SQL Server Books Online.
Deploying SQL CE version 3.5.8080.0.
Development system is 32 bit Windows 7 Home Premium SP1 version 6.1.7601.65536.
System installed SQL CE version is 3.5.8080.0.

For several months of development there have been no issues with this setup.  A month or so ago I began getting an occasional error message while making updates to the application in the development environment.  The message dialog would come in waves of three several minutes apart and would subside once I rebuilt the project.  The error message is "Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider version 8080".
The application uses a designer generated DataSet.  While trying to add an additional TableAdapter from the DataSet to the main form the above mentioned error dialog, for which I would click OK, would try to prevent changes from being made.  After several design environment restarts and restoring the impacted form.Designer.vb and .resx files I could finally complete making changes in the form designer.

The changes in the designer were not carried over into the

VS2010 Professional .NET 4.0 Remote Debugging ASP Website Project


Trying to remote debug ASP website from VS2010 Pro to Windows Server 2003 machine.  Specifically, trying to debug a Web Service, but breakpoint says, "The breakpoint will not currently be hit. No symbols have been loaded for this document."  This happens for all compiled code though.  I have read this is due to missing PDB files and the work around is to manually copy them, as noted here.  Problem is, I cannot find any PDB files for my project, except referenced libraries, which I can remote debug.


  • web.config has <compilation debug="true">
  • Debugger is attached to wewp.exe process on remote server
  • Installed VS2010 remote debugger from DVD (as I can remote debug referenced libraries)

This is beyond frustrating.  I migrated my code from VS2008 .Net3.5 to VS2010 .Net4.0 to take advantage of the inherent multithreading framework.  Debugging works when using local host and was stable until deployment to test server.

Thanks in advance,


HttpHandler works with Visual Studio Development Server debugging, but not otherwise


Hi all,

I'm new to HttpHandlers.  I am writing an HttpHandler that reads uploaded files directly from the request stream to provide progress that can be queried using an AJAX request.  For large files, this seems to be faster than having ASP.NET load the file contents into Request.Files and then streaming the file from there to wherever it goes (Linq to SQL into a VARBINARY column in an SQL Server database.)

My HttpHandler works perfectly when I'm debugging using the Visual Studio Development Server, but doesn't work otherwise.  The application pool for this application in IIS 7 is set to run in Classic Mode, and the Handler Mappings screen in IIS says that I must manage managed handlers in system.web/httpHandlers. 

I set up in my applications Web.config file.

<add verb="GET,POST" path="*.upload" type="Namespace.For.UploadHandler, AssemblyForUploadHandler"/>

It works great, so long as I don't debug with the "Use Local IIS Web server" option.

What else do I need to do to get this to work?


IE 8 Issues with Chinese/Japanese Characters


On my web application, I display information in different languages. Everything works fine in IE compatibility mode and FireFox but it shows boxes for chinese/japanese languages. I am pretty much having the same issue as described here



Thanks for your help.

Multiple MSIs from one deployment project


We have several .NET based products for which we need to generate multiple MSI files to allow for multiple instances of the same app to be installed on the same machine.  For instance, we might have a single server running version of the app that are pointed at either test or QA databases, or may use the same server box to deploy the product for multuple clients.  (So, for instance, our web server might have separate installs of the same code in different locations for product names "Client A test", "Client A QA", "Client B Test", etc., where the only real differences are in the web.cionfig files that are not overwritten by the install of a new version.)

Right now we simply have a deployment project for each named variation of the app.  This works, but is likely to become a maintenance mess as the number of instances grows.  We'd like to be able to maintain only a single deployment project and script the creation of multiple MSIs, one for each product variation, after the build of a baseline MSI.

As I understand it, this should be acheivable by building the MSI, then for each possible instance, making a copy of the MSI and giving it a unique ProductCode and PackageCode; this way Windows should recognize each instance as a unique application.  I've done this (as well as changing the produc

web deployment project (WS_deploy) on VS2008


I am building a asp.net webservice in VS2008 and the web service compiles and debug fine. The project should be using : Net 3,5

 I have

  1. VS2005 and VS208 installed
  2. .Net 1.1 - 3.5
  3. WebDeploymentSetup for VS2008 (and most likely a version for VS2005 as well)

But when I add a web deployment project the fun stops. The .WS_deploy project will not compile and I cannot find any precompiled output.

--------------debug output-------------------

------ Build started: Project: **************.DAL, Configuration: Debug Any CPU ------
Build started 13-08-2010 08:17:14.
Target EntityDeploy:
    Processing 0 EDMX files.
    Finished processing 0 EDMX files.
Target CoreResGen:
    No resources are out of date with respect to their source files. Skipping resource generation.
Target CopyFilesToOutputDirectory:
    **************.DAL -> C:\Development\VS2008\**************\**************.DAL\bin\Debug\**************.DAL.dll

Build succeeded.

Time Elapsed 00:00:00.14
------ Build started: Project: **************.BLL, Configuration: Debug Any CPU ------
Build started 13-08-2010 08:17:14.
Target EntityDeploy:
    Processing 0 EDMX files.
    Finished processing 0 EDMX files.
Target ResolveProjectReferences:
Target CoreResGen:
    No resources are out of

vs2010 web deployment project restarts w3svc even when restartwwwservice = false


We've updated some of our projects from VS2008 to VS2010.  When these projects are deployed the w3svc is restarted on the target machine, even when restartwwwservice = false in the vdproj file.


This was a problem in 2008 until SP1 (http://forums.asp.net/p/1300097/2534736.aspx).  Does this same problem exist in VS2010?


This is a major problem for us -  we need to be able to deploy projects without restarting IIS.


I've tried creating a new web deployment package and setting the restartWWWService field to false, but this still does a restart when it's installed.


Has anyone come across this problem in VS2010?

Web deployment project - web.config section replacement does not add remove tag


I have a web application that is actually installed as a component of a third party site.  In some configurations, I need to remove certain connection strings and re-add them.  I'm replacing this web.config section with a xml file that includes the following:

      <remove name="MyOverridenConnection"/>
      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

For some reason the remove tag is left out during the substitution and I end up with the following in the installed config:

      <add connectionString="Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDb;Data Source=MyServer" name="MyOverridenConnection"

Is there any way to issue removes in replaced sec

Web Deployment - Setup failing - aspnetca.exe


I have created websetup in windows 7 environment, asp.net 3.5, IIS 7.

Client System is windows 7 and IIS 7

Our client configuration is Windows 7, IIS7 dotNet Framework 3.5.
Following error raising below...
Faulting application name: aspnetca.exe, version: 7.5.7600.16385, time stamp: 0x4a5bcd3c
Faulting module name: aspnetca.exe, version: 7.5.7600.16385, time stamp: 0x4a5bcd3c
Exception code: 0xc0000005
Fault offset: 0x0001d912
Faulting process id: 0xe80
Faulting application start time: 0x01cb3604624975cd
Faulting application path: C:\Windows\system32\inetsrv\aspnetca.exe
Faulting module path: C:\Windows\system32\inetsrv\aspnetca.exe
Report Id: a05d368d-a1f7-11df-8336-4487fc612414
PFA Here I"m attaching custom action script. 

Web Deployment with IIS settings of remote server


Im trying to deploy a web application project (VS 2010) via team build (TFS 2010), i got to use IIS settings of development server for deployment. So from the project properties I configured the web projects to use Custom web server, (enabled radio button), once i do this the Option in the tab Package/Publish Web "Include all IIS Settings as configured in IIS manager" gets disabled and as a result the deployed web project does not have this IIS settings.

What am I missing here, Im not using the option "Use local IIS Web Server" because the build happens in a build server and would try to take local IIS settings for packaging which is not present.

If this is not possible, suggest me any workaround. Any help on this is greatly appreciated.

Could not load file or assembly - Web Deployment Project



I have the following projects in a solution :

- A Web Application

- A Class Library

- A Web Deployment project

The Web Application compiles and run fine when I don't go through the Web Deployment Project. However when I try to use that, I get the following error:

Error 1 An error occurred creating the configuration section handler for hibernate-configuration: Could not load file or assembly 'NHibernate' or one of its dependencies. The system cannot find the file specified. (F:\Folke\Folke.csproj_deploy\Release\web.config line 4) 1 1 Folke.csproj_deploy

"An error occurred creating the configuration section handler for hibernate-configuration: Could not load file or assembly 'NHibernate' or one of its dependencies. The system cannot find the file specified. (F:\Folke\Folke.csproj_deploy\Release\web.config line 4)"

This is the beginning of my Web.config:


SMTP not working if I use web deployment package to deploy my app.


Hi all

I use msdeploy to install my web app. deployment package. everything about web app works, but find out email was not working.

I checked telnet smtp is running.

I debug the project, and it was sending out email too.

So my solution was upload the whole project (not complied) to wwwroot, and email works too. Thats why I assume the deployment cause the problem.

at last, I also tried to copy the web deployment web.config to replace the project's web.config, and the email also work, so it wasn't the web.config problem.

Could anyone tell me whats going on?

My environment:

window 2003

iis 6

.net framework 4.0

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend