iT Synergy Blogs

Growing Innovation - Soluciones a problemas reales

  • Facebook
  • Instagram
  • LinkedIn
  • Phone
  • Twitter
  • YouTube

Copyright © 2025 · iT Synergy·

Cannot resolve the collation conflict between “Modern_Spanish_CI_AS” and SQL_Latin1_General_CP1_CI_AS” in the equal To operation.
Cannot resolve the collation conflict between “Modern_Spanish_CI_AS” and SQL_Latin1_General_CP1_CI_AS” in the equal To operation. avatar

June 6, 2013 By Ana María Orozco Zuluaga Leave a Comment

Sometimes when you are working with different database to get data the way you require, you can get the next error:

Msg 468, Level 16, State 9, Line 3: “Cannot resolve the collation conflict between “Modern_Spanish_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.”

It happens because the database collations of those two database I was working on have different collation as show the next two pictures:

To resolve the problem you have to identify the column which are presenting the problem. Normally you can identify them in two cases:

  • If you are working with a simple query like:

Select *

From Tabla

Where Cond1 = Cond2

The “issue” is going to be in the data you are using in the clause Where.

  • If you are working with a Merge sentence like:

MERGE PISGRSTG_Dev.dbo.Fuente AS T

USING PISGR_Dev.dbo.Fuente AS S

ON T.IdTipoRecurso=S.IdTipoRecurso AND T.IdTipoEntidad=S.IdTipoEntidad AND T.IdEntidad=S.IdEntidad

WHEN NOT MATCHED BY TARGET THEN

INSERT ……

VALUES….

WHEN MATCHED THEN

UPDATE SET

T.Con=S.Con,

…….

 

The “issue” is going to be in the data you are using in the clause On.

As I was using a Merge statement in this case I fixed the error as show below:

ON T.IdTipoRecurso=S.IdTipoRecurso AND

T.IdTipoEntidad=S.IdTipoEntidad AND T.IdEntidad=S.IdEntidad COLLATE Modern_Spanish_CI_AS

 

Is Like make a cast between two database collations.

Filed Under: SQL Tagged With: Collation

SQL – Saving Changes is not permitted
SQL – Saving Changes is not permitted avatar

May 31, 2013 By Ana María Orozco Zuluaga Leave a Comment

Have you been working on SQL Server when you realize that you need a new column in a table or make any kind of change like allow null for a specific column ?

The easy and fast way to make a change is using the design option to add the new column. Most of the time it allows you to introduce the name and the DataType you need to create.

By default SQL server, is going to show you an warning message when you committed the changes you have made in the table. The warning doesn’t allow you to save the changes and show you the follow message: “Saving change is not permitted”. The change you have made require the following tables to be dropped and re-create. You have either made changes that cant be recreate or enable the option prevent saving changes that require the table to be re-create.

This happens because SQL has activated an option by default, which doesn’t allow you to do that. in this post I am going to Show you how to change that option. However you have to be careful changing this and I recommend you just do it in a developer environment, not in production environment.

So, to change that go to Tool – Designers and Prevent saving change that require table re-creation as show the next figure:

 

Filed Under: SQL Tagged With: BI, SQL Server

Consultas en SQL Server 2012 utilizando Full Text Search
Consultas en SQL Server 2012 utilizando Full Text Search avatar

February 12, 2013 By Yully Arias Castillo Leave a Comment

Algunas veces es necesario realizar consultas complejas de palabras o frases en una tabla, SQL Server ofrece la funcionalidad de Full Text Search que permite ejecutar consultas de textos sobre una tabla o una vista en una base de datos.

A continuación se describe como crear un Full Text Index sobre la tabla a consultar.

1. Crear el FULL TEXT CATALOG.

clip_image001[6]

1. Se nombra el Full Text Catalog y se selecciona la opción OK.

clip_image003[9]

2. Hacer clic derecho sobre el Full Text Catalog creado, en properties se selecciona la tabla y los campos donde se realizaran las búsquedas.

clip_image005[9]

3. Para realizar la búsqueda por los campo seleccionados se ejecuta el siguiente query:

clip_image007[9]

La sentencia SQL hace una búsqueda de la palabra “Mark” en los campos FirstName, LastName o City

Se pueden utilizar la cláusula CONTAINS cuando se requiere una búsqueda exacta o aproximada del criterio de búsqueda o FREE TEXT para las búsquedas que se necesitan que coincidan con el significado y no con la palabra exacta.

Para más información ver el siguiente link http://msdn.microsoft.com/en-us/library/ms142571.aspx

Filed Under: SQL, SQL Server

  • 1
  • 2
  • Next Page »

Team


Marco
Antonio Hernández

Jaime
Alonso Páez

Luis
Carlos Bernal

Ana
María Orozco

Juan
Camilo Zapata

Diana
Díaz Grijalba

Carlos
Alberto Rueda

Sonia
Elizabeth Soriano

Alexandra
Bravo Restrepo

Bernardo
Enrique Cardales

Juan
Alberto Vélez

Diana
Paola Padilla

Jhon
Jairo Rodriguez

Jesús
Javier Hernández

Alejandro
Garcia Forero

Gustavo
Adolfo Echeverry

Yully
Arias Castillo

Carlos
Andrés Vélez

Brayan
Ruiz

Jimmy
Quejada Meneses

Natalia
Zartha Suárez

Josué
Leonardo Bohórquez

Oscar
Alberto Urrea

Odahir
Rolando Salcedo

Carolina
Torres Rodríguez

Juan
Mauricio García

Mario
Andrés Cortés

Eric
Yovanny Martinez

Tag Cloud

.NET (9) 940px (1) Analysis Services mdx (1) An attempt was made to load a program with an incorrect format. (1) ASP.NET MVC (1) Azure (3) Backup (1) BAM (7) BAM API (1) BAMTraceException (2) BI (3) BizTalk (24) Business Intelligence (6) C# (2) caracteristicas de publicacion (2) Content Editor (3) ESB (15) ESB Toolkit (3) General (4) habilitar caracteristicas (3) indexes (2) Integration Services (2) Master Page (3) MDX (2) MSE (11) net.tcp (2) Office 365 (2) Oracle (2) Performance Point (2) Public Website (2) Receive Location (2) SDK (2) Servicio Web (2) Sharepoint 2010 (2) SharePoint 2013 (4) SharePoint Online (2) SOA (8) Soap Fault (2) Sort Months MDX (2) SQL Server (2) Visual (2) Visual Studio 2010 (2) WCF (19) Windows (3) Windows 8 (17)

Categories

  • .NET (33)
  • Analysis Services (1)
  • ASP.NET MVC (2)
  • Azure (7)
  • BAM (9)
  • BAM PrimaryImport (3)
  • BigData (1)
  • BizTalk (77)
  • BizTalk 2010 configurations (57)
  • BizTalk Application (60)
  • BizTalk Services (13)
  • Business Intelligence (4)
  • Cloud (3)
  • CMD (1)
  • CodeSmith – NetTiers (2)
  • CommandPrompt (1)
  • CRM OptionSet mapping component (1)
  • Desarrollo de software (6)
  • develop (6)
  • developers (3)
  • DropBox (1)
  • Dynamics (1)
  • Enterprise Architect (1)
  • Entity Framework (1)
  • Errores BizTalk (2)
  • ESB (27)
  • ETL (1)
  • Event Viewer (1)
  • Excel Services (1)
  • Foreach loop container (1)
  • General (4)
  • Gerencia de Proyectos (2)
  • Google (1)
  • Grouped Slices (1)
  • Human Talent (1)
  • IIS (4)
  • Integración (6)
  • Integration Services (3)
  • KingswaySoft (1)
  • Lync (1)
  • MSE (13)
  • Office 365 (2)
  • Oracle Data Adapter (2)
  • Performance Point (4)
  • Picklist (1)
  • Pivot Table (1)
  • Procesos (1)
  • Pruebas (1)
  • Public Website (2)
  • Reports (1)
  • SCRUM (1)
  • SDK (2)
  • SEO (1)
  • Servicios (2)
  • Sharepoint (9)
  • SharePoint 2010 (10)
  • SharePoint 2013 (4)
  • SharePoint Online (2)
  • SharpBox (1)
  • Shortcuts (1)
  • Sin categoría (1)
  • SOA (50)
  • SQL (5)
  • SQL Server (3)
  • SQL Server Management Studio (1)
  • SSIS (3)
  • SSL (1)
  • SSO (1)
  • Tracking Profile Editor (2)
  • Twitter (1)
  • Uncategorized (1)
  • Virtual Network (2)
  • Visual Studio 11 (1)
  • Visual Studio 2010 (2)
  • Visual Studio Online (1)
  • VMware (2)
  • WCF (24)
  • Web (1)
  • Web Api (1)
  • Windows (5)
  • Windows 8 (11)
  • Windows Azure (2)
  • Windows Live Write (1)
  • Windows Phone (7)
  • Windows Phone 8 (1)
  • Windows Scheduler (1)
  • windows8 (2)
  • WindowsRT (3)
  • WP7 SDK (1)

Manage

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org