Meow Now (10/22/2014)

---

Oh, and thanks for all the hard work Steve & Co. This site saved me nearly a decade ago when I suddenly inherited my first DBA position and...

What Perry said.

Windows name unique. SQL instance names unique on a host.

Kansas City had some great BBQ when I was there for SQL Sat. They did a mini BBQ crawl on Friday, hitting a few places.

Excellent, and I'm sure I gained...

Jeff Moden (10/22/2014)

---

Steve,

After a fairly long wait (> 30 seconds), I got the following...

Sorry, an error has occurred

If problems persist, please contact us to let us know.

When reporting this error,...

Ed Wagner (10/22/2014)

---

I whole heartedly agree. Steve is the major driving force behind SSC and a big part of why I've called SSC "home" for more than a decade....

Correct, as Gail mentioned, no script generation, or at least, not in one stage.

Here's what I'd do.

Set up the restore in the GUI, moving paths/folders as needed. Don't click "OK",...

spaghettidba (10/21/2014)

---

rodjkidd (10/21/2014)

---

I want to go to at least one SQL Sat in Italy. November is probably a no go due to going to PASS, and December is so full...

Gail is correct, you need to restore things as they were. You can move drives/folders, but not files.

Is this a one time thing or do you do this often? If...

Create a table with a varchar of 1500 (or more) in length. You can insert with BULK INSERT or SSIS (or the import wizard). Map each line, no delimeter, to...

I'm with Gail. Two parameters. At some point you may refactor this and you'll want the separation.

spaghettidba (10/21/2014)

---

Jack Corbett (10/21/2014)

---

I think there are fewer overall posts and most of the posts are by people who have very little understanding of or experience with SQL...

Good for you, Lynn. You coming back to the Springs, I assume?

Lynn Pettis (10/20/2014)

---

I thought there was a forum for the Redgate tools but I can't seem to find it.

What I was looking for was if there is a command line...

Thanks. It's a challenge, but it hasn't been too bad most of the time. Lots of just plugging away, which I'm good at. Plus no co-workers to distract me 😉

The...

There isn't a great way to do this. You'd probably need to think about importing as ints, then transforming with the appropriate number of 0s ahead of things based on...