Attach is faster. But that really doesn't cover the question. The real question is what are you doing? Are you moving a database from one server to another? Then detach/attach...

To do that properly, so that the user doesn't get access, you need to open up a programming language, VB, C#, whatever, and create an executable.

Otherwise, a simple solution would...

Unless you've done modifications to it (in which case, you really should have a tested backup around that you can restore from) model is generic. Do you have another instance...

GSquared (12/7/2010)

---

Steve Jones - SSC Editor (12/7/2010)

---

Brandie Tarvin (12/7/2010)

---

I have to wonder if this thread is encouraging people to respond more harshly to articles, posts, etc. Certain we've seen an...

No, not at all. The natural behavior of the optimizer is to rearrange the join order, right out of...

I hated geometry, so don't look at me. But even if someone could write the function in TSQL, they shouldn't. It's not something that the T-SQL language is going to...

I guess I'm still confused as to what you're going for, but sQL Server knows which databases it uses to maintain itself. It works with them and there's very little...

Yep, what Steve said. Sorry I wasn't clear. It's a domain account that I was describing without saying it properly.

No, SQL Server should run as an account on your system that has access to that drive. We usually use a common service account for most of our systems, but...

Why do you care? What are you trying to do? If Paul White's script here doesn't do the job, what is that you're looking for?

shaun.turner (12/6/2010)

---

Hi all,

So I don't usually post my problems on these forums as I tend to prefer to find the answers myself but this one has me stumped and I'm...

Size could be an issue in the decision, but I'd look to complexity. If the import is extremely simple, just a column mapping, I'd use TSQL to do it. If...

I don't completely understand what you're trying to do here. SQL Server backups should be run from within SQL Server using the backup syntax:

BACKUP DATABASE X TO DISK = 'some/location'You...

Luke L (12/6/2010)

---

Grant Fritchey (12/6/2010)

---

GilaMonster (12/5/2010)

---

Don't go for tonnes of plugins. Get ones you really need (like syntax highlighting), add more as the requirements arrive.

I've only got 7 plugins in...

I'm running with 4...