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


Post New Web Links

Any way to debug using the server GC on a workstation?

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :.NET Framework
 

Hi,

We have a race condition somewhere in (some rather twisted) Dispose() logic that only shows up when the app is hosted on a server running under IIS.  If we try and repro on a dev machine (even multi-core), the problem never happens.  It's a pain trying to attach the debugger to IIS for a number of reasons (mainly because some assemblies are dymanically loaded and lifetimes are managed by WCF).  Is there any way to run a console app from dev studio with the Server GC enabled to our unit tests can attempt to reproduce and diagnose our problem?  Thanks!

-Erik


Erik Johnson


View Complete Post


More Related Resource Links

MSDTC - TransactionOption "Required" works from my XP Workstation but not from our 2008 Server

  
I have a SSIS package (2008) that has a sequence container with TransactionOption Required.  This is needed to ensure that multiple tasks commit or fail together.  It also has a custom transformation that establishes (acquires) connection objects. This package works great when run from my local XP workstation.  I can see the distributed transaction starting and committing in the SSIS output. The problem is that when I roll this package out to the server, it fails to acquire the connection, throwing an error at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectinoMAnager100.AcquireConnection(Object pTransaction).  I've verified that the security settings of MSDTC on this server are consistent....they are definitely set to allow inbound and outbound. Are there any issues with MSDTC on Windows Server 2008?  Is it possible that I'm getting an issue because my workstation is 32 bit but the server is 64 bit? Thanks -Mark

SQL Server on a network workstation

  
I recently installed Microsoft Expression Studio 2 and Visual Studio 2008 on my workstation for web development.  After the instalation my Network Server started displaying error messages that there were duplicate IP addresses being assigned.It was as though there was another server on the system trying to hand out IP adresses.  I disabled the SQL srvices on the workstation with MS config and the Server stopped getting erors.  Any ideas on how to run SQL on my workstation would be helpful.  If this can't be done, can I uninstall SQL from the workstation and still use the Expression Studio 2 package? Thanks :-)

RijndaelManaged works on workstation, not on server

  

I have a project that uses the RijndaelManaged class for encryption/decryption.  It works fine on my workstation (xp 32-bit), but when it gets deployed to Windows 20008 Server (64-bit), it gives the following error:

"Specified key is not a valid size for this algorithm."

 


Need to debug IIS deadlock on Sharepoint server

  

We have a problem with a sporadic deadlock that occurs on our primary production Sharepoint 2007 farm. When it occurs we have to manually reset IIS as all sites stop responding. When it occurs it is usually around 5:00AM when the UK would be coming on line and working

Configuration:
1 x WFE, 1 Search, 1 SQL server
Sharepoint 2007 SP2 with Dec cumulative updates
2 primary web apps

I have installed debugdiag and created a crash rule to capture any faults in IIS process, but that is not capturing the data when the deadlock occurs.

When I setup a hang rule it fails on the verification of URL with a 401 Unauthorized error. I have turned off loopback checking on our test server and it fails with this same error. I am able to access the site via IE on the server. This hang rule is the only thing i see that would trigger a dump to be captured when the site did not respond.

Is there  a better way to approach this? The goal is to have something configured to trigger a dump when the deadlock event occurs

Thanks,

Jonathan


How to run Scripts in Debug mode to run queries step by step in Sql Server 2008

  

Hi all

i am working on SQL Server 2008 i dont know to how to use the debuging mode to Run Scripts

so that to check Scripts step by Step  please help me out i am wasting my time for checking the error please provide me any link that provides article & Demonstration

thanks in Advance

Sunil Yoganna


2008 server Access database connecting win7 workstation with ODBC link works extremely slowly

  

I have an Access database on a 2008 server (64 bit), and notebooks with 32 bit win7. The program using the mdb is written in delphy, and running on my notebook, and working on data extremely slow. What can be the problem?

The database connector is an ODBC linked network drive.

On that same configured PC with XP it works normally.

Pappxla


how to use visual studio to debug sql server reporting service 2008 by attaching process

  

I did custom security extension and want to debug it. I used to debug it using visual studio by attaching its iexplore.exe process using visual studio 2005 and sql server reporting services 2005. After then, I can debug UILogon.aspx.cs and AuthenticationExtension.cs in Microsoft.Samples.ReportingServices.CustomSecurity.dll. When I set break point, it can reach.

Now I used 2008 version for all application. After I attaching process, it can't reach break point I set. I realize sql server reporting services didn't use IIS and it use another component to hold web app. I may affect it and unable to debug it ? Do I need to do any configuration or any thing before I can use visual studio 2008 to do debug by attaching process ?

thanks

Gary

 


Unable to import from Excel on 64-bit Win 7 workstation to a 32-bit Windows 2003 Server running SQL

  

Hi,

I recently moved from Windows XP to Windows 7 on my primary workstation, and since then I'm unable to import from Excel to SQL from any of my SSIS scripts when I run them Locally.  The one instance I'm running into now is importing from Excel 2010 on my system (64-bit Windows 7) to SQL Server 2008 running on 32-bit Windows Server 2003. 

Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)   Jul  9 2008 14:43:34   Copyright (c) 1988-2008 Microsoft Corporation  Standard Edition on Windows NT 5.2 <X86> (Build 3790: Service Pack 2)

I even tried creating the import through SSMS and saving it as an SSIS script to get the same results.  The only thing I can think of is the change of architecture on my workstation.  I'm running 64-bit Windows 7 and the server is 32-bit Windows Server 2003 and SQL Server 2008.  Below is the Validation text SSIS returns:

Validation has started
[SSIS.Pipeline] Information: Validation phase is beginning.
Progress: Validating - 0 percent complete
[Source - Sheet1$ [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "SourceConnectionExcel" failed with error code 0xC00F9304.  There may be error messages posted before this with more

Pkg (Server) or Agent to Remotely execute another Pkg on workstation (PC)

  

Good day, i need help.

Migrating Servers & SQL from 2005 to 2008.

We have a package that 1.extracts data & 2.process cognos cubes on the old server, do not want to install Cognos on new server as it will be discontinued in a few months. Old server will also be trashed soon.

I have been asked to manually check when 1.extracts data pkg has completed & then Manually 2.process cognos cubes on my PC.

I do not want want this, Is there a way from within the one pkg or agent to Remotly execute another pkg on my PC?

Please Assist, really would be great if i could do this.


call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side.

Making Ajax Callbacks to the Server Using jQuery with ASP.NET

  
In the first part of this article series I introduced jQuery's functionality and how it provides a rich client side programming model. This time around I'll expand on these concepts and show you how you can use jQuery in combination with ASP.NET using it as an AJAX backend to retrieve data. I'll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in WebForms.


jQuery is just a JavaScript library so it will work seamlessly with ASP.NET both from page code as well as through backend driven code using the Page.ClientScript object or ScriptManager. You can use jQuery on its own as a client side and Ajax library that communicates with ASP.NET or you can use jQuery in combination with ASP.NET AJAX. The two actually complement each other quite well as jQuery provides functionality that the ASP.NET AJAX library does not and vice versa. For the most part the interaction between the two libraries is trouble free except for a few very rare edge cases.

MS SQL Server: Disconnect Users From Database - Kill User Session

  
If you ever wanted to restore your database from a SQL backup file (.bak), but there are still users connected to your database, the backup operation will fail causing the error: Exclusive access could not be obtained because the database is in use.

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

call JavaScript - jQuery code from ASP.NET Server-Side

  
jQuery got so close to me lately that I can see myself adding the scripts to my project almost unconsciously. The thing is, jQuery is very useful for me, in almost all situations and it has been a do or die enhancement for all my project since I first put my hands on it.

Of course while using it, you encounter few situations which need a bit of research to solve, mostly when you are trying to combine it with some other technologies like: UpdatePanels and ASP.NET Ajax. For instance there are many situations when I would like to run some jQuery magic based on some decision that I make on the server side

Publishing SQL Server Database using Publishing Wizard : Tips & Tricks

  
We can use SQL Server Publishing Wizard to deploy our local Database to remote hosting server/production server.This feature is available in SQL Server 2008/VWD 2008.

Below is the complete step by step guide of this process.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).

IP Address Blocking or Restriction in SQL Server

  
"is it possible to block connections to SQL Server based on IP address". As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.


.Firewall
.IPSec
.RRAS IP Filter
Categories: 
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