Michael Earl (10/10/2008)

---

My suggestion is to stop the services on the original servers, copy the databases (including the system databases) to the new servers, and start the services on the...

Cool... I can do that. Thanks for the heads up on that.

noeld (10/10/2008)

---

I would do it this way:

1. Take a full backup of each DB, Compress it and start log shipping it. You can d that "NOW".

2. After you are...

Michael Earl (10/10/2008)

---

The servers are physically different, but can you convince them to retain the original server names and IP addresses?

If so, keep everything simple. Stop the services on...

My apologies... I forgot to say that they're all SQL Server 2000 Enterprise Edition servers which also means that I just posted to the wrong bloody forum... :blush: I don't...

jcrawf02 (10/10/2008)

---

Just curious, if you are working in an environment where DBA's DON'T know not to use sp_, is there another way to filter out the system procs and keep...

Just to give physical representation of Kenny's suggestions...

--===== Create a temporary demonstration table and populate it with duplicated info

-- This is not part of the...

Thanks for the feedback, Michal. Heh.. No... no searches for the word "cursor" or "while"... that would easily become a full time job on this forum alone. 🙂

One more... DBCC SHOWCONTIG. It produces a report on whether the index(s) on a table actually need to be defragged....

Chris Morris (10/10/2008)

---

Hi chaps, this might sound a little blasphemous, but have you tried Visual Foxpro for importing the data? I worked with the product extensively in the 90's (MCP...

Sergiy (10/9/2008)

---

One day some developer will read a conversation like this and decide it's good to use "thorn" character as a replacement for CR/LF.

He/she will agree it with other side...

Heh... I agree with that, Seth... that's why I'll always print it out and try a couple of pieces first, just to be sure. Thanks for the feedback.

Thanks for the feedback, Richard. 🙂

If you have the DVD version of MSDN, you probably already have the Developer's Edition just waiting for you on one of those disks.

mahesh.kumar (10/9/2008)

---

Hi,

I have a updation on a datefiled for everyminute in all the records hence if i create a index on datefield wont it give a problem in writing..

Thanks &...