The thing to do is have a separate PK, either identity or GUID, and then store the data, but allow for mistakes. Give them a confirm, maybe on the next...

Thanks for the update and glad they got back to you.

Pinged the guy in charge of samples. We'll see if he responds.

Jerry has a decent idea. Just attach the databases. I think I did that for 2008.

Interesting responses, especially Mia's. I do think that it is easier for the average DBA to manage more instances, but it seems instances grow, and grow, and grow. And I...

Tend to agree with Jeff here. If you have nothing specific to learn, start learning what interests you and the forums here are a great place to apply the things...

It's always a balance. We complain and ask for things to be fixed, stabilized, sped up, and there are changes made in those areas, but it's a business and there...

The storage engine is interesting since you learn how things work inside the server. I'd also pick up Grant Fritchey's Execution Plan book from Red Gate software.

Is there something in...

There really is no good way to do this if you don't have the space at all. You can play some games, perhaps shrinking tempdb, or detaching other dbs and...

Sounds like the tool flaked. I wouldn't worry about it unless it happens again.

There might be a third party component to send SMS, but you're better off just using email to do this.

This is a SQL script, shouldn't matter if you have 32 or 64 bit.

Read-only makes perfect sense, and in that case, you do want a smaller restore.

However as disks fill up, performance does suffer, so even with read only, you want some buffer...

I'd bet it's more often how not...

I'm wary of recursive CTEs as well. And concerned that because something appears clearer, you use it instead of something better. Another thread had a discussion on a left join...

If you run this as a select without the CAST, what comes back. Chances are you're missing something there.

I might use CHARINDEX to find the right spot, maybe with a...