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


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

Should I change my Server Collation ???

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :Sql Server
 

My server collation is SQL_Latin1... as all my databases were upgrade from earlier version.

Should I plan a change to the collation to a window's based collation?




View Complete Post


More Related Resource Links

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

Cannot change the collation sequence of a Database in SQL Server 2008 R2

  

I tried two steps below separately: restricted user ran for 30 minutes then I stopped the execution; They obviously could not run simultaneously. I only want to operate at the database and not the server level. Our other key db is already in the desired collation. We'd like to have equijoins work on tables with the same collation sequences, and not have to use ETL or individual ALTERs for each table involved.

Second point: is CP1 below a 2000 only collation? That appears to be a patently false assumption in another forum posting. It appears to be a valid 2008 R2 collation is the point.

ALTER DATABASE DBNAME

SET RESTRICTED_USER WITH NO_WAIT;

ALTER DATABASE DBNAME

COLLATE SQL_Latin1_General_CP1_CI_AS ;

 

Many Regards,

MM

 

 


what's the right collation for sql server 2008 to ignore french accent?

  
I want to  sql server 2008 collation using english as default(in Canada). when search for text, french accent can be ignore. For example, À,Â,Ä, à, â, ä will be treated same as a or A, but the data still is stored as different(such as for key). so what is the right collation need to be selected when install sql server 2008?. If existing instance collation is not the right one, how to change it to the right one?

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 Collation SQL_Latin1_General_CP1_CI_AS versus Latin1_General_CI_AS

  
Hi,Why does SQL Server 2005 sometimes install with a server collation of :Server Collation SQL_Latin1_General_CP1_CI_AS and other times a server collation of :Latin1_General_CI_ASWhat causes this ???What is the difference between the two ?Are there any problems restoring databases from one to the other ? Do the two different collations cause problems with applications ?

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 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.

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 when change single column collation

  

I try to change a collation on column FirstName on table Person. Then I got following error:

Msg 5074, Level 16, State 1, Line 1
The index 'IX_...' is dependent on column 'FirstName'.
Msg 4922, Level 16, State 9, Line 1
ALTER TABLE ALTER COLUMN FirstName failed because one or more objects access this column.

So should I drop the index before the change and create it again after the change? Any other possible impact on existing data for such kind of change?


SQL Server 2008 collation design techniques

  

Can anyone provide some insight into design techniques when multiple languages are required within SQL Server?

Let me tell you about our situation. We currently have a database that holds French content. New languages are going to be added (Chinese, Arabic etc.). We have to make a decision to determine what would be the best approach to deal with all those languages.

 

Here are the approaches we identified:

 

o   I database per language:

Changing Clustered SQL Server 2005 Default Server Collation

  

We are attempting to change the default collation of an SQL Server 2005 Clustered environment. We have created an "unattended install" script to perform this, and have modified it several times as errors have arisen repeatedly. The last time, however, we used the following script:

start /wait setup.exe /qb VS=<FQN of SQL Server Virtual Name> INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 ADMINPASSWORD=<adminpwd> SAPWD=<NEW sa pwd> SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS SQLACCOUNT=<domain\user> SQLPASSWORD=<pwd> AGTACCOUNT=<domain\user> AGTPASSWORD=pwd GROUP=SQL Group REINSTALLMODE=vomus

We are running this script from the primary (Active) node of the cluster. We did notice that the bootstrap logs created from this final execution did include logs from both nodes. When I look in the Summary.txt file, it tells me that Setup succeeded with the installation. After the script executed, we rolled the cluster from primary to secondary, and rebooted the primary node. We then rolled the cluster back to the primary, and rebooted the secondary node. Once that was complete, we cycled the SQL Server service from the SQL Configuration Manager. After all those steps, we opened SSMS client to look at the properties of master, and the collation was still CI_AI.

We are losing valuable time in

Report Server change

  

Hello All Experts,

In my live server we have total nos of approx 200 reports and 50 email subscriptions created by us.

Now we are planning to change our existing hardware configuration and due to some other reasons, now the current live server we will not use in future, In view of same we want to move our all our reports and email subscription to other new server and that new server will be our next live server.

Now the problem is that i have 50 email subscription which i have created in old server so how can i move this subscription to new server ?

Reports can be deployed to new server by taking the backup. Is there any other concern in such situtation?

Please suggest me and any other feedback regarding the same.

Regards,
AKM 


Report Server change

  

Hello All Experts,

In my live server we have total nos of approx 200 reports and 50 email subscriptions created by us.

Now we are planning to change our existing hardware configuration and due to some other reasons, now the current live server we will not use in future, In view of same we want to move our all our reports and email subscription to other new server and that new server will be our next live server.

Now the problem is that i have 50 email subscription which i have created in old server so how can i move this subscription to new server ?

Reports can be deployed to new server by taking the backup. Is there any other concern in such situtation?

Please suggest me and any other feedback regarding the same.

Regards,
AKM 


SQL Server 2008 R2 Setup: How to set Collation during interactive setup?

  

Hi!

Did I miss something when running SQL 2008 R2 Setup.exe on Win2008 Server R2?  I did not notice my opportunity to set the server collation to something other than my regional default.  Was it on a tab that I missed?

Are my choices either (a) set collation at the OS level through Control Panel...Regional...Advanced, or (b) run setup.exe at the command prompt while specifying the desired server collation?  Because I get that impression from reading this: http://msdn.microsoft.com/en-us/library/ms144260.aspx

Have I read that correctly?

Thanks!

Tom

 


change language of 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


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