charindex can take a third parameter, the location at which to start. Use the charindex from the first one as the starting point.

SELECT line1 = substring(TXTFIELD,1,charindex(CHAR(13),TXTFIELD))

, line2 = substring(TXTFIELD,charindex(CHAR(13),TXTFIELD),...

You'll need to change the logins. This data is stored in the server, so if the outside domain changes, you need to either setup trust or change the logins. You...

Sorry, look for blocking. Mistyped earlier.

Are these two dedicated servers for testing or production? Can you answer on hardware?

cache? Are you clearing this before testing?

That's not much of a difference though. Could be other factors.

Yes, it is all humans, not just Americans. Was thinking here at home we need to lead the way on copyright. Start here and then see if others will follow...

weird as in Steve is weird, weird Steve picked a weird topic, or it's weird I think Steve made sense 😛

I vote for the original 14 years + 14 extended.

We...

The response from YouTube is well done and it outlines the issues. They need to protect themselves because of the laws. It also seems to hint to the McCain campaign...

This does sound strange and I don't think this happens often. It's likely an anomaly as mentioned above. If it happens again, I'd recommend calling MS, running PSdiag, and posting...

If you're willing to do Broker, I'd do that. It gives you some flexibility to move the archive to another server/system easily later if need be. Harder to do that...

First of all, is the hardware the same? Or how is it different? Check drivers, especially disk drivers, as issues there can really affect performance.

Next, you have to examine plans...

could be a lot of things, hardware, load on either server, disks, etc. check the plans, be sure they're running efficiently, look at load on the servers, check the speed...

Is it always the year after?

Convert the year to a number if it's not, add one, convert to char, take the right 2 characters.

Use

CAST() and RIGHT()

And please watch the forums. Moved to the DTS forum.

Well SQL 2005 supports 6.5 versions, which are 10 years old. however I'm not sure of the upgrade / restore policy.

Honestly what I've done in the past is archive the...

If you are getting connected to SQL Server, then you should see databases. If you uninstalled and reinstalled, did you re-attach databases? If not, they won't be there.

If this is...