SQL Server 2008 does not use UTF-8 anywhere in terms of storing data internally, and neither does SQL 2012.

SQL 2008 stores unicode data using UCS-2, a subset of UTF-16LE...

Alternative:

EXECUTE...AT

http://msdn.microsoft.com/en-us/library/ms188332(v=sql.105).aspx

See example G. This way we can force a select to execute on the remote server.

If you have a table ready that matches the shape of the SELECT you...

If you can change what your input parameters mean you will have a much simpler time querying your data in my opinion. Let's say we changed it to mean this...

chumphrey 12211 (4/6/2012)

---

I am a newbie!!! I have a 2008 R2 Standard Ed server with a database that is in Simple Recovery. The database had a large amount...

You've got several concepts going on here that you need to learn before you can get all the way through the task. Here are a couple videos that cover some...

Not sure, but your registered SPNs may need to be updated after the rename if the FQDNs change with the rename.

OK, I think I ruled out the block-level copy step as a possible problem. I just successfully restored the supposedly problematic-backup to a different 2008 R2 server in the remote...

Here's the equivalent T-SQL solution:

WITH cte

AS (

...

You're sample data is still causing trouble...but I polished it a little to the point where it will at least run. here is a sample using the SQLCLR Aggregate:

IF EXISTS...

I wish I could...the 2005 and 2008 R2 data centers are geo-separated and...

No worries on the name, happens all the time.

Did you see Gail's post? I think she is onto something 😉

The RESTORE VERIFYONLY returned clean:

Can you post the DDL for DateL2?

This part of your update statement will not tolerate NULLs:

WHERE CollectionPrefix = @CollectionPrefix

...

GilaMonster (4/6/2012)

---

I can pretty much tell you that it is not a corrupt page in the source DB. There is no page 0:0 in a database, and if page 1:0...

We must have been typing at the same time...ditto to everything Lynn said. In order to help further we need to see DDL (i.e. CREATE TABLE statements), DML to create...