It sounds like you have a SQL 2000 database that you backed up on SQL 2000 and restored on SQL 2008, then you want updates to the 2000 database to...

Dwain,

A "Quirky Update" isn't going to work here, as the problem isn't just a matter of retrieving a value from a previous record. It's a matter of finding...

maida_rh (12/17/2012)

---

Ok...waiting for an helpful repli which will be a treat for me......

msdb...database is in SQL data folder but dont know how to restore packages and got a link which...

There are a number of ways to execute a package, and as I haven't seen SQL 2000 in quite some time, I don't recognize your click sequence, so you'll have...

ScottPletcher (12/17/2012)

---

Since you have to ALTER columns only one at a time (why, MS, why??), I'd create a new table and INSERT every row into it, converting every column at...

Glad to see this is finally sorted... and with good results, too...

From a query perspective, one should not get in the habit of simply moving a JOIN condition to the WHERE clause. It will only be a matter of...

PiMané (12/17/2012)

---

Hi,

There's no UNICODE data for sure... but there are 5506 columns that need to be converted, involving 2013 indexes and 2740 FK.... So manually isn't an option.

I've already managed...

John Mitchell-245523 (12/17/2012)

---

Well, you could do the join in Integration Services. Or maybe Reporting Services has similar functionality as well - I've never tried it. But just because...

veloopity (12/17/2012)

---

thanks for the quick reply ... can I simply change the data types in the table design view? will the data that are already in there stay unharmed by...

Before worrying about how to script it, you have to worry about the data. If you know beyond a shadow of a doubt that NONE of the characters...

Glad to hear it works for you, although I'm thinking there might be a better way than to just regenerate the data every time you need it. If...

Ok, I see where I had trouble. Here's a fix, but I'd be concerned about it's performance with a large volume of records. It might be...

Ok, so what method of getting the data into SQL Server did you have in mind? There are quite a few ways to do it. You...

We need a little more detail here... You stated that the "Package execute successfully", but didn't specify what process was used to do so, e.g. SSIS, DTS, a...