.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

Collation issues

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

Hi, when sending scripts to update client databases they sometimes fail to execute as the destination server has a difference collation than our development server. What is the prefered method to overcome this issue.

Many thanks,


View Complete Post

More Related Resource Links

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.

Concurrency: Tools And Techniques to Identify Concurrency Issues


Efficient parallel applications aren't born by merely running an old app on a parallel processor machine. Tuning needs to be done if you're to gain maximum benefit.

Rahul V. Patil and Boby George

MSDN Magazine June 2008

CLR Inside Out: Investigating Memory Issues


Memory issues can manifest in a wide variety of ways. This column shows you how to collect the data you need to determine what types of mem¬ory issues you are experiencing.

Claudio Caldato and Maoni Stephens

MSDN Magazine November 2006

Stress Testing: Custom LoadGenerator Tool Identifies the Issues Your Application Faces Under Stress


It's easy to postpone stress testing when developing an application, and it's easy to forgo it altogether. Having an easy-to-use framework at your fingertips to conduct these tests can make the task far less painful. This article walks you through an application that eases the task of generating load for a variety of layers within an application.

Brian Otto

MSDN Magazine April 2004

Versioning Issues With Optional Arguments

One nice new feature introduced in C# 4 is support for named and optional arguments . While these two features are often discussed together, they really are orthogonal concepts. Let's look at a quick example of these two concepts at work. Suppose we have a class with one method having the following signature. // v1 public static void Redirect( string url, string protocol = "http" ); This hypothetical library contains a single method that takes in two parameters, a required string url and an optional string protocol . The following shows the six possible ways this method can be called. HttpHelpers.Redirect( "http://haacked.com/" ); HttpHelpers.Redirect(url: "http://haacked.com/" ); HttpHelpers.Redirect( "http...(read more)

Issues with Visual Studio 2010 editor


hi all,

I am having a weird problem with VS 2010. I am using the premium edition.

It seems that none of the asp controls <asp:..> tag are recognized by the editor. I keep getting a green underline under each control name. To check this, I have created a brand new web site targeting .NET framework 4.0 and even in the auto-generated pages, none of the asp controls is recognized. I am also unable to see the properties of any control if I click inside the tag (at an attribute). All I get is the ID of the button and the tag <HTML ELEMENT>! Furthermore, when I drop an ASP control from the toolbox, the attribute "ID" is not generated. Only when I switch to the design view that I can get to see the properties of the control and the ID is set automatically. The message for the green underline says: Element 'Button' is not a known element. This can occur if there is a compilation error in the Web Site, or the web.config file is missing.

Does anyone know what is going on?





Session Variable issues


Hello everyone,

I ran into an issud to day with the follwoing code.  The strPanelOrder session variable is false, however, once it goes into the next if statement and sets the strTrimOrder to True, it changes the strPanelOrder session varialbe to true as well.  Why is this and how to I stop that from happening?

If Session(strPanelOrder) Is "False" Then
                If (strItemNumber.Length() = 10) And (strItemNumber.Substring(0, 2) = "FS" Or strItemNumber.Substring(0, 2) = "FC" Or strItemNumber.Substring(0, 2) = "DS" Or strItemNumber.Substring(0, 2) = "DC") Then
                    Session(strPanelOrder) = "True"
                End If
End If
If Session(strTrimOrder) Is "False" Then
               If (strItemNumber.Substring(4, 1) = "T") And (strItemNumber.Substring(0, 2) <> "AC") And (strItemNumber <> "Length") Then
                    Session(strTrimOrder) = "True"
                End If
End If


Thanks in advance for taking a look at this.



Session issues with IE8



I am trying to invoke a window using the following commands:

Response.Write("<script>" & vbCrLf)"

Response.Write(window.open('" & url & "','','toolbar=0,status=1,resizable=1,scrollbars=1,menubar=1');" & vbCrLf)"


The problem however is that on IE8 the session object is not carried over to this new window. I get "Nullpointerexception" when I try to retrieve the connection object from the session. It works on IE6 though.

Any help would be greatly appreciated.


Migrating aspnet tables to dev server - having issues



We're trying to migrate a one of our apps to our dev server for testing and development, but we're having problems with the membership functionality. We can add users, but there seems to be a disconnect with roles. We can query the aspnet_users table and find the new user in there, but when we query the aspnet_usersinroles table, that user id is not present.

We're also unable to run the Roles.GetUsersInRole("somerole") method. It returns 0 records. When I run Roles.ApplicationName, it returns the correct name, so .NET should be passing the correct app name.

We're just a little baffled. If anyone could shed some light on what could be the issue, we would appreciate it.

Thanks! :)

Trying to get Roles to populate a checkboxlist based on tutorial and having issues.


I have been using the following tutorial and had to convert the code to C# for my project, now i cant get the code to work, im getting red line under the word "in" in the UpdateRolesFromList,
i tried to add a datasource on page load for the checkboxlist like so RoleList.DataSource = PopulateRoleList(User.Identity.Name.ToString());

and gives me error saying cannot implictly convert type 'void' to 'object'


What am i missing, that when i load the page or even do a search it never displays the checkbox list as it shows in the tutorial?

        protected void Page_Load(object sender, EventArgs e)

        public void PopulateRoleList(string userName)
            string[] roleNames = null;
            string roleName = null;
            roleNames = Roles.GetAllRoles();
            foreach (string roleName_loopVariable in roleNames)
                roleName = r

Workflow timing issues?


I am creating a new workflow using SPD on MOSS 2007, SP2, and having a problem with it.

The workflow is fairly basic, where when a user creates a new infopath form it sends an email to another person, who enters some info, then selects where it get's routed to next.  There are 3 more similar processes before the form is marked as completed.  At each step the WF emails the person selected as next reciepient and updates a "flag" saying which step the process is in.

The problem is that sometimes when I update a form, (all emails come to me since it's still in testing), the workflow stops with a message of "Failed on Start (retrying)".  After doing some digging I found this link:


So I went in and added an action for every update I do to first check the document out, do the update, and then check the document back in.  Well the problem I get now is that the WF fails with a message about unable to check the document back in.  I tried troubleshooting it by putting in WF Stop and Log entry actions to try to figure out exactly where the problem was happening.

I thought I had fixed it

Info Path form when modified by using UTF-8 encoding having issues with existing 'iso-8859-1' char



I am modifying the infio path form 2007 from my state machine workflow to constantly update the status fields in the request form.

below is the method i created for the same..

private void updateInfoPathRequestForm(string xpathNode, string nodeValue)
            SPUserToken token = workflowProperties.Web.CurrentUser.UserToken;
            using (SPSite _site = new SPSite(workflowProperties.Site.ID, token))
                _site.AllowUnsafeUpdates = true;
                using (SPWeb _web = _site.OpenWeb(workflowProperties.Web.ID))
                    SPListItem item = _web.Lists[workflowProperties.List.ID].Items[workflowProperties.Item.UniqueId];

MVC 1 - Issues with the homepage - IIS7


Has anyone ever had strange behaviour with deployed MVC websites on IIS7.

Our homepage shows intermittent strange behaviour as follows

1 - Postbacks sometimes are not processed server side, sometimes postbacks change the URL and add random query string parameteres

2 - Server side code in the Index Action is sometimes not called when the homepage loads (we have some data we load in from a cookie on the Index action of Home Controller, intermittently this data is not loaded in.

3 - Tracking - We have a really strange issue whereby some people who hit or site on the homepage are being tracked by Google Anayltics, Our internal tracking database (which uses a cookie) and some other third party software as bounces and then the second page they hit is being logged.

It seems as if randomly, server side code is not being executed from our homepage only. All other pages are fine, this only ever happens on our homepage

Are there issues around MVC homepages in IIS7 - has anyone else ever seen this behaviour ?

Issues with SharePoint 2010 Installation


Hi All,

I have got error while installing sharePoint 2010 as follows and answer also present below,but i could not able to find the patch as mentioned in the solution below I.e: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\UpdateExeVolatile"

I my machine is not the base machine its a VM running with Windows Server 2008 standard and SQL Server 2008 R2......

ANy help much appreciated...

ISSUE #3:  when running Setup.exe for Microsoft SharePoint Server 2010 you may experience the error:

Setup is unable to proceed due to the following error(s):
A system restart from a previous installation or update is pending. Restart your computer and run setup to continue.
For the list of pre-requisites needed to install the product please refer to:
Correct the issue(s) listed above and re-run setup.

Check the value of the following Registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\UpdateExeVolatile - if the value of the UpdateExeVolatile Registry key is anything other than 0 you will see this message.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Pendi

Issues accessing saved documents in SharePoint


Hello, I believe there is an issue with a current document link in SharePoint.  When we click on the main Document Folder (labelled - Project Descriptions) we are typically provided access to a large list of subfolders and documents.  For some reason now, when we click on the main Document folder, a dialogue box opens up prompting me with the following language:

Do you want to open or save this file?

  • Name: Allitems.zip
  • Type: Compressed (zipped) Folder, 6.13KB
  • From: sharepoint.ambit-consulting.com

If you click "open", you're redirected to a blank page in SharePoint.  Our documents are no where to be found.  Please help.


Josh - AMBiT Consulting Inc.

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