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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

change language of sql server

Posted By:      Posted Date: September 28, 2010    Points: 0   Category :Sql Server
 

hi

there is an step in installing process of sql server 2005 that you  can change the language. this alphabet language is used in ORDER BY and ... . How can i find this tool from sql server, manualy?.

Best Regards. Morteza




View Complete Post


More Related Resource Links

How to Localize Windows Forms and Change the Language at Runtime

  
Localization is the process of customizing your application to a particular language, culture or locale. Visual Studio provides support for localizing Windows Forms with much ease. In this article, we will see how to localize windows forms and give the user the ability to change to his preferred language at runtime.
When you run a localized application, the appearance is determined by two culture values. The UICulture property is used to specify which resource files will be loaded for the form. The Culture property, on the other hand, determines how strings such as dates, numerals, and currency amounts are formatted.
Let us see the steps required to create a localized form. You can then expand this example and adopt the same approach for the rest of the forms in your project

Change Button Text in Multi Language Website

  

Hi i developing multi language website

using Master pages

everything fine

Page_Load i set the Text property of Button Control from Resource file

like this

Button1.Text = GetLocalResourceObject("Button1")

then in the button click event i cnage the text of the Button control

Button1.Text = GetLocalResourceObject("Button1_new")

but the text doesn't change and no error messgae

what is the problem how to solve this

 


change page language

  

Hi all, 

I am new to this forum and want to know how can i change the page language.

For example English -> Hindi..

Do any one have any Idea ?

-Thanks. 


MSSQL 2008 R2: Change Server Collation Steps, with user DBs already of desired collation

  
On the default instance of SQL Server 2008 R2, I want to change the server collation from the usual US default SQL_Latin1_General_CP1_CI_AS to an application vendor's required collation, Latin1_General_BIN.  I understand that changing the server collation is essentially the same as changing the collation of databases master and model -- is that a fair statement? But my main question is, since there are user databases on the server that I would like to preserve, can I not simply detatch the user DBs prior to performing the server collation change, and then reattach?  The database collation of the user databases is already set to Latin1_General_BIN.  This article, Setting and Changing the Server Collation, at http://msdn.microsoft.com/en-us/library/ms179254.aspx says that to preserve the user databases, I should script all DB objects out, and bulk-copy all data out, because the DBs will have to be recreated and repopulated.  Can someone explain why I ought not simply detach and reattach the user DBs, given that they are already of the desired collation (i.e., the same collation that I will be changing the server collation to)? Your help much appreciated. -Tom

SQL Server Compact loses change tracking anchors when copied to device

  
I have a device app that use SQL Compact and uses sync framework to synchronize to a SQL Server 2008 instance.  In order to speed up the initial synchronization of my device app, I'm creating the database (.sdf) using the sync framework on the server based on the suggestion in this article: http://msdn.microsoft.com/en-us/library/dd938879.aspx#HandlingInitialSynchronizationandExpiredSubscriptions Then I get it via a WCF service down to the device app.  I'm able to download the db and it has data.  When I sync however, the database doesn't seem to think it is syncronized.  It seems to have lost it's anchors.   The following code returns an anchor for my State table on the server, but not after copying it to the device. Any suggestions are appreciated.  Thanks FPASQLCeClientSyncProvider).GetTableReceivedAnchor("State")

Server Time Dimensions - language mix

  
I'm making my first steps with SSAS and as part of my test project, I added a server based time dimension. During generation, I configured the langage to be German (Germany) (the machine and Visual Studio are set up in English). What is being generated is a mix between English and German though - the calendar year and quarters remain in English, and the months and day of week are in German. Shouldn't the whole hierarchy be in the language I chose? I'm using SQL Server 10.0.2531.

Failed to change Farm Account in Sharepoint 2010 server, now Central Administration is not accessibl

  
Hello, I have a problem, that I no longer can access Central Administration Website, only the Sharepoint itself. I was running installation of Sharepoint 2010 Server with administrative account ImTheAdmin, who is a Domain Admin in the domain on one of the Windows 2008 R2 member servers. Besides that, I made ImTheAdmin the primary administrator of the Sharepoint. ImTheAdmin became the only user of this Sharepoint 2010 server after installation.  I installed everything on one box with default installation settings. I used builtin SQL server, not Standard or Enterprise. What then happened is: Using ImTheAdmin account, I opened Central Administration Website, and it said, that I need to change the Farm Account, for the account for Farm was the default one (I think it was network service). So I created a regular domain user MYDOMAIN\SharepointFarmAccount. The account name was too long to be as a Windows 2000 name, so it showed there without last 't', e.g. MYDOMAIN\SharepointFarmAccoun. I thought, Windows 2000 is long gone, so I didn't pay much attention, I think everywhere the account SID is important. I don't know if that is the real problem with my failure later, but it might be one of the reasons. I put MYDOMAIN\SharepointFarmAccount down in to the form of Central Administration Website, added the check mark, that it would react to password changes, and pre

Change language, or change homepage? And drop down menu?

  
Hello I just startet using Sharepoint Server 2010, and im having a little problem with the default homepage. I want to change the language to danish or make a new home page in danish? I also want to make drop down menu's at the top bar?   Thanks in advice...

How to change WSS 3.0 Home site language?

  
Hi there, I have WSS 3.0 + internal database + Latvian language instaled, but home site is still in English, how to change home site language ?

Install SharePoint Server Language Packs.

  
Hi, can someone confirm if you need to install the SharePoint Foundation Language Pack in addition to the SharePoint Server Language Pack? In other words, does the Server Language Pack include the Foundation Language Pack? Thanks in advance, Dirk Van den Berghe

Change SQL Server DB

  
hi . I Install Basic Sharepoint . SHarepoint DB has Create On SQL\OfficeExpress and SQL\Express Have Limited (4 gig ) for MDF File Size . I Want deattach DB from SQL\Express and Attach it in SQL Enterprise . when I do it my Site dont work . I think , I need define a DB where but I do not know where .

how to change the web application Database connection form Windows authentication to SQL Server acco

  
Hi, I have a web application created and Database connection authentication was given as Windows authentication. how can i change it to a SQL server account in MOSS 2007. Thanks in advance.

Internal server error exception on search results page when no language is set in browser

  
We have some users who receive an internal server error exception when they enter a search query on our SPS 2010 site. The SharePoint log shows the following: Internal server error exception: System.ArgumentNullException: Value cannot be null.  Parameter name: The property RequestedLanguage cant not set to NULL     at Microsoft.Office.Server.Search.Query.Location.set_RequestedLanguage(CultureInfo value)     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.CreateLocationList()     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.SetPropertiesOnQdra()     at Microsoft.Office.Server.Search.WebControls.SearchResultsBaseWebPart.EnsureWebpartReady() System.ArgumentNullException: Value cannot be null.  Parameter name: The property RequestedLanguage cant not set to NULL     at Microsoft.Office.Server.Search.Query.Location.set_RequestedLanguage(CultureInfo value)     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.CreateLocationList()     at Microsoft.Office.Server.Search.WebControls.CoreResultsDatasourceView.SetPropertiesOnQdra()     at Microsoft.Office.Server.Search.WebControls.SearchResultsBaseWebPart.EnsureWebpartReady() After some more diggin

Arabic Language Support in SQL Server 2005

  
ummary: Microsoft SQL Server 2005 supports Arabic data in Unicode and non-Unicode formats. Get information about the Arabic language code page, collations, components, and functions, as well as feature-specific information concerning set up, administration, replication, data transformation, and more.

How to change SQL server 2008 collate after installation

  
Hi, On windows sever 2008 I've installed SQL server 2008 RC0.At the time of installation, I'd specified the collation as LATIN1_GENERAL_BIN, and now I want to change this collation to LATIN1_GENERAL_CI_AS.Please note that I don't want to change the collation of specific db but need to change the sql server 2008 server's settings.How to accomplish this requirement with minimum efforts?Thanks

Change from MOSS embedded DB to SQL Server

  
We've just purchased Axceler Control Point but just realised it won't work with a standalone instance of MOSS 2007. Is it possible to install SQL Server then migrate from standalone to a SQL Server instance? If the answer is yes, a point in the right direction re documentation on 'How-to' would be appreciated. I apologise as this has probably been asked a thousant times already.

Error configuration Wizard WSS3 "The Language is not supported on teh server"

  
The following error happens during step 2 of the Configuration Wizard.

****** Error MSG from log******
  Task configdb has failed with an unknown exception
Exception: Microsoft.SharePoint.SPException: The language is not supported on the server. ---> System.Runtime.InteropServices.COMException (0x8102005E): The language is not supported on the server.

***************************

If I start the Wizard again I now get:
************
Exception: System.InvalidOperationException: Windows SharePoint Services configuration infrastructure is not initialized.  You must wait until completion before joining another server to the farm.
************

If I delete the databases and start again I get the first error msg again. 
I have uninstalled and reinstalled WSS3  SP2 numerous times.
The DBServer is the same machine.

TFS 2010 RC is also running on this server.

Any suggestions or help would be appreciated.
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