You could detach each database, move the mdf/ndf(if any)/ldf files to their new location, then attach the databases.

Scripts like that are usually pretty specific to the database being copied. You might want to look at the Copy Database wizard for what you are trying to accomplish.

Grant Fritchey (8/20/2009)

---

Lynn Pettis (8/20/2009)

---

Kit G (8/20/2009)

---

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before,...

Kit G (8/20/2009)

---

RBarryYoung (8/20/2009)

---

FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before, if you guys could...

Here is my first suggestion, start first by reading about these thngs in BOL (Books Online, the SQL Server Help System). It may not be the greatest thing since...

Two things. First, from the description provided it is really difficult to provide you with any real help. Second, why do you think you need a cursor? ...

gah (8/20/2009)

---

if you are saying that all customer / locations combinations should be in table CustomerLocation and you want to find the combinations that are "missing" then please try this

SELECT...

Half Bubble (8/20/2009)

---

I never think of union.

This isn't quite it either. I'm looking at 18 customers and 2 locations, so there should be 18*2 customerlocations. Your query finds me 2...

Not being mind readers or having access to your systems, can't really help you from here without more help from you. Please provide the DDL for the table(s) (Reduce...

setlan1983 (8/20/2009)

---

Lynn Pettis (8/19/2009)

---

This is just a simple left outer join:

select

entryt.EmpName,

entryt.EntryDateTime,

exitt.ExitDateTime

from

dbo.EntryTable entryt

...

Half Bubble (8/19/2009)

---

An SQL puzzle that's tripped me up. I wound up doing it brute force.

Simple Many to Many between Customer and Location. Intervening table is CustomerLocation. They are linked...

This is just a simple left outer join:

select

entryt.EmpName,

entryt.EntryDateTime,

exitt.ExitDateTime

from

dbo.EntryTable entryt

left outer...

Curious, base on other posts I am wondering what your position is with your company? Mind letting us know?

No problem. Guess I need...

Attached you will find some code that hopefully meets your needs. I have tested against your sample data, and it seems to work. I haven't had time to...