Sorry I coudn't get back earlier.

To make the long story short it is the conversion to Unicode what messes up the data because 'Œ' is not part of the...

"Shipto" DATA TYPE, Please

If the "real-time" part is "very real" you have no choice but replication!!!

Usually this kind of maintenece is performed with Jobs. If you can query job status and next run date/time you should be able to  aviod the contention

The Message is loud and Clear

An explicit value for the identity column in table 'Employees' can only be specified when a column list...

SET @sSQLCmd='

  update sv

     set sv.SupplierInternalKey = t.SupplierInternalKey,

         sv.PublicationStatus = 1

    from [' + @sServerName + '].[' + @sDbName + '].[dbo].SupplierItemAttributeValue sv, #MainSupplier t,

   (select ChangeLink, store

      from #emsstores...

Couple of questions:

What is the data type of "shipto"?

What is the Collation of your database ?

Update Yourtable

Set FName = Left(File_ext,Charindex('.',File_ext)-1),

    EXt = right( Rtrim(File_ext),3)

DECLARE @SQLStatement2 NVARCHAR(255)

DECLARE @Myvar int

select @SQLStatement2 = 'select @Myvar = low FROM [' + @servername + '].master.dbo.spt_values WHERE number = 1 and type = ''E'''

exec sp_executeSql @SQLStatement2, N'@Myvar...

The statement you are trying to run returns a recordset and... you are trying to save a bunch of records in an integer variable?

Eric,

Are you actually executing the statements with the commented part or are they just compiled in a stored proc?

also can you post the DDL of  "DW.dbo.DIMPromotion" and "#DimPromotion"...

Yo need to move the connection out of process. There are two possible solutions to this kind of problems.

1. Implement it with DMO instead of OpendataSource.

2. Use a job to...

EugeneZ ,

All the functions used in that query are documented!!

Not all possible queries can be...

The article is good but I think is overcomplicating the solution. Greg Larsen's Article besides using an undocummented feature is also missing a simple posibility:

select *

from openrowset('SQLOLEDB',

                'Trusted_Connection=yes; Initial...

Sean,

Once Again!

• When you write something to be posted on the internet you need to have boundaries.
• When you do it on a SQL Server site, it better has something to do...