No announcements
Found 2154560 threads
-
1 Voteschange collation for each table in database
use INFORMATION_SCHEMA.COLUMNS table and look for columns with different collation. then generate code using below query SELECT 'ALTER TABLE ' + ...Answered | 3 Replies | 1312 Views | Created by ymarkiv - Friday, February 7, 2014 12:05 PM | Last reply by Visakh16 - Friday, February 7, 2014 2:29 PM
-
1 Votes
database collation change
SQL server manages collation in 3 levels: server, database, table (column).Answered | 5 Replies | 12086 Views | Created by Manu_vmr - Tuesday, March 22, 2011 10:08 PM | Last reply by WeiLin Qiao - Saturday, March 26, 2011 5:35 AM -
0 Votes
How to change Database and all table columns collation in same time??
The script don't change the collation, it generates a change script, which you have to execute to do the changes.Answered | 8 Replies | 2677 Views | Created by Jafferpg - Thursday, August 11, 2016 3:53 PM | Last reply by Jafferpg - Friday, August 12, 2016 10:20 AM -
1 Votes
Collation and temporary tables issues (collation changes system by system)
If your database uses a single collation, but the server may have a different collation, database_default should work out.Answered | 5 Replies | 3833 Views | Created by fasttrack - Friday, June 8, 2012 9:28 AM | Last reply by Steen Schlüter Persson - DK - Friday, June 8, 2012 1:29 PM -
0 Votes
Restoring a database and changing collation, available options?
As for the fastest way to import a database and change the collation - that depends on the size of the database and the complexity of the schema.Answered | 3 Replies | 2512 Views | Created by Robtyketto - Friday, July 5, 2013 7:48 AM | Last reply by scott_morris-ga - Friday, July 5, 2013 5:54 PM -
0 Votes
Database Collation VS Column Collation
I have some Collation problem I need a help, please!Answered | 2 Replies | 7046 Views | Created by KDWolf - Friday, June 27, 2008 5:40 AM | Last reply by Dan Guzman - Wednesday, January 1, 2014 7:00 PM -
1 Votes
Changing collation on import
You can use ALTER DATABASE to change the database collation, but this only changes the collation of the system ...Answered | 5 Replies | 1207 Views | Created by DarrellDoesData - Wednesday, September 16, 2015 8:03 PM | Last reply by Erland Sommarskog - Friday, September 18, 2015 9:42 PM -
1 Votes
Change Database Collation To Handle Accents And Tildas
The link that I sent you has a code to go through the tables in your database and change the collation settingsAbdallah, PMP, ITIL, MCTSAnswered | 6 Replies | 8610 Views | Created by JustinK101 - Thursday, November 19, 2009 7:34 PM | Last reply by Abdshall - Friday, November 20, 2009 9:21 PM -
0 Votes
Collation Change
Change the collation settings of all user databases.Answered | 5 Replies | 2023 Views | Created by Federico Staiano - Friday, January 16, 2015 9:35 AM | Last reply by Uri Dimant - Monday, January 19, 2015 10:35 AM -
1 Votes
Table variable and collation
Hi Simly, It will use the collation of database x, If the COLLATE property of the table varible was not specified, the column is ...Answered | 4 Replies | 11239 Views | Created by Simly - Monday, September 9, 2013 2:35 PM | Last reply by Candy_Zhou - Tuesday, September 10, 2013 7:10 AM -
0 Votes
how to change collation for databse
Create a new empty database with the needed collation and move all objects /data from the old to the new database..Answered | 9 Replies | 2688 Views | Created by vinayvarala - Tuesday, December 10, 2013 5:14 PM | Last reply by Uri Dimant - Wednesday, December 11, 2013 8:15 AM -
9 Votes
sql server database collation
What I mainly had in mind is that with a binary collation, you cannot get get "usd" in the Transactions table, or any other table ...Answered | 12 Replies | 9157 Views | Created by Gugan.t - Thursday, January 16, 2014 5:22 PM | Last reply by Ed Price - MSFT - Tuesday, January 21, 2014 2:54 AM -
0 Votes
Collation conflict while joining two tables within the same database!
Here is a shocker: collation is actually table column property!Answered | 4 Replies | 2783 Views | Created by Theroyale - Monday, January 30, 2012 11:15 AM | Last reply by Kalman Toth - Monday, January 30, 2012 12:46 PM -
3 Votes
Changing SQL Server Collation
Is your plan to change just the instance collation or also the database and column collations?Answered | 4 Replies | 6323 Views | Created by CanadaBoy - Tuesday, June 11, 2013 9:41 PM | Last reply by Kalman Toth - Wednesday, June 12, 2013 10:57 AM -
5 Votes
Collation of database objects
Now we have database objects created with the original collation that are failing due to collation conflicts.Answered | 5 Replies | 5104 Views | Created by Kiwi Jonathan - Tuesday, November 16, 2010 9:21 PM | Last reply by Kalman Toth - Wednesday, November 17, 2010 1:38 AM -
1 Votes
collation setting of database
I already mentioned this; the database collation is only a default setting used when you create a new table + columns without defining explict ...Answered | 4 Replies | 3080 Views | Created by Mayur-DEW - Friday, August 31, 2012 5:51 AM | Last reply by Olaf Helper - Friday, August 31, 2012 7:50 AM -
0 Votes
Problem with Database Collation settings
Becasue I have plenty of procedures/fns pointing to both of the databases There is no way out.Answered | 2 Replies | 1482 Views | Created by M Tiwari - Wednesday, June 26, 2013 6:09 AM | Last reply by SQLZealots - Wednesday, June 26, 2013 6:23 AM -
0 Votes
Database Collation for Movemenet
Hi DeepakTyagi28, According toAnswered | 3 Replies | 2247 Views | Created by DeepakTyagi28 - Thursday, April 18, 2019 6:44 AM | Last reply by Puzzle_Chen - Tuesday, April 23, 2019 5:44 AM -
0 Votes
Collation in the table
Can I change collation for this columns ?Answered | 5 Replies | 5001 Views | Created by Marek G_ - Thursday, December 30, 2010 10:26 AM | Last reply by Erland Sommarskog - Thursday, December 30, 2010 11:28 AM -
0 Votes
Cannot change the collation sequence of a Database in SQL Server 2008 R2
The following links have scripts to change all column collations: How to change database or server ...Answered | 7 Replies | 12964 Views | Created by Methody M - Wednesday, August 18, 2010 10:22 PM | Last reply by Kalman Toth - Friday, September 24, 2010 5:51 PM - Items 1 to 20 of 2154560 Next ›
No announcements
