Honestly I think you'll end up wasting tons of time moving this data. I only think that custom SSIS type scripts will work here, and since you are changing schema...

Kit G (8/3/2010)

---

Those who practice Islam need to answer that question to the satifaction of those who don't practice Islam (and the same goes for any other religion). Until...

Alvin Ramard (8/3/2010)

---

Roy Ernest (8/3/2010)

---

You should see the looks I get from the Security at all airport when I am flying... 🙂 They take my passport, and come back after...

Sorry, I found it yesterday and should have updated this thread. We're not sure what happened, but think it was a broken process that re-ran last night and fixed things.

Good reference, and I hadn't realized a clean shutdown is needed. That's good to know.

Jack Corbett (8/3/2010)

---

WayneS (8/3/2010)

---

Well, since Steve asked for opinions on one topic, let me broach another topic.

What do you'll think about this[/url]? Is there a valid point? Are the people...

Another example of an article that doesn't show America in its best light. There might be places where I think race should be taken into consideration, but this isn't one...

Are you using a local instance here? The server OS matters here. I don't believe this works on workstation OSes or pre-W2K3. It does work on my local Win 7...

Not sure. I've had a number of 1-2, 2-3, 3-3 days. I was at .400 a little over a month ago. Since then I'm sure I'm in the low .300s.

At...

Enterprise Manager would be too old. It uses an older client technology. SSMS should pop up a dialog.

The client receives a message, and then should display a dialog. It's possible...

How far north do you have to be?

Note that you being the only resource for a system, or one of a few, doesn't mean you can't do anything else. Even if someone wants you to be dedicated,...

There's a checkbox if you are on W2K3 and later

http://msdn.microsoft.com/en-us/library/ms161959.aspx

About a year after 9/11, I had to fly to CA every month. Every single trip I had something taken from me, either in Denver, or SF. Same bag, same...

Here you go, this should help

http://msdn.microsoft.com/en-us/library/ms151870%28v=SQL.90%29.aspx