Why move the whole thing?

Just move the user databases to the new drive.

Dettach all dbs.

COPY to the new drive.

Attach at new location.

Run check db to ensure you have the dbs...

I've done data transfers like this to access, excel and dbase and while it wasn't has fast as sql server it was decent enough... especially if this is a 1...

I'd check the server collation setting. I'm pretty sure they are not the same. Or the collation of the database has been changed in the move.

Keep in...

stephenjohnson9 (6/1/2011)

---

Thanks for your reply guys

@ninja's_RGR'us I think you might be right on this one just makes it a lot more easier, Do you have any information on steps...

How the heck can those 18 tables have exactly the same columns and same meaning???

What was the source of the problem?

What error are you getting or what is wrong with the output?

aagaag (5/31/2011)

---

WOW, that was fast! Many, many thanks. The executable is, at the moment, just a BLAT.EXE command that sends a bunch of emails. Later , however, more sophisticated things...

Here's the very best link for this : http://tinyurl.com/3tblqmu

Long story short, don't do it.

If you absolutely have to. Run a service or a job that polls a queue table for "records to process" and then process them....

Sorry to hit the same nail over and over again. But a SINGLE sp is not the correct tool for this.

ORM or linq seems much better.

Or you can go...

tfeuz (5/31/2011)

---

G Squared --

Thanks for the note -- that was what I was looking for -- not a solution, just something to look into.

I have never used a "cross...

There's no point in using a sp for that... just do it adhoc.

What's the real business need behind this request?

Last one I swear :w00t:.

Might be good you read this as well :

http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

One more ref.

More than you need to know about sql plans an index tuning by "our" own Grant Fitchey

http://www.sqlservercentral.com/articles/books/65831/

Sorry to burry you like this with articles but even...