You don't have to create the database, and yes, there's a password on the file.

Typically SQL backups have .bak as the extension, not BKUP.

Jeff,

We have two developments ongoing. One was our regular developer/week a month that I believe tried to fix some code items. Those are in test now, AFAIK. We have a...

Bob,

Thanks for the kind words.

I'll think about the rest. I hear what you're saying, not sure how to implement it. Or what would make sense.

Moved to the career forums. Please watch where you post.

I think you can, by showing some work with those platforms as a part of your current job. Or showing some...

foursaints (4/6/2009)

---

Steve -

I know this thread will get a lot of mileage, but my goodness I hope you read my post here:

While I'm at it I'd like to throw...

Andy Warren (4/6/2009)

---

Steve, on a side note, it would be really interesting to see if you can't find a way to identify/flag what those posts/posters might have in common. Are...

Andy Warren (4/6/2009)

---

Food for thought on those answering posts - one of my sayings is that "you have to be in the right place in life to lesson some lessons",...

Mario,

I'd actually ask you start a new thread for that. It's a great question, and I think it deserves some debate. If you post a URL here to it, I'll...

I checked this on 2005, and both answers marked as correct (A and D) work.

You have to run each SET/SELECT and then a SELECT @val for each answer, with separate...

And how did it get...

Thanks, Bob. I almost didn't run that one. It grew out of a few threads over the last month or so. Had me a little exasperated one day.

There are, but unfortunately we don't have enough good...

I think you're ready to be a DBA some day! It's unintuitive for many people, but I tend to agree with you....

homebrew01,

Please update us if you learn anything from the advice here. This is a great discussion.

Interesting comments, I'll have to think on a few before posting more.]

As an FYI, Lynn has a great blog here on this same subject.