You could join with the information_schema.columns to get those names, but it might be easier to do it manually if you know the columns and are writing the code:

select name...

Dont' forget heartbeats, which you usually want on a separate network.

We have a three part series on building a 2 node cluster that should help you: http://www.sqlservercentral.com/articles/Clustering/73994/

You haven't explained what you issue is, nor what the conditions mean for the logic. You need to stop and go over the functionality you need, build an algorithm in...

Did you upgrade to R2? are you sure the TF is still enabled?

If you can have an archive offline, just take a backup and store that. If you need it online, create a new database, as Remi and Grant suggested, and then...

The physical separation on drives is more important than the controller. While you could saturate the controller's bus, usually you get more bottlenecking on the drives themselves. You'd have to...

We've talked about it. It's quite a bit of "touching" of the code, so we have been debating whether we want to undertake major changes in the forums, or add...

You are welcome, and would love to hear if any developers or DBAs go down the route of creating their own apps.

Kiara (9/8/2011)

---

Jack Corbett (9/8/2011)

---

Side note, my dad (nearly 80) fell last night and broke his hip. Needs surgery. I'd appreciate prayers as his health is not good to...

SELECT @Output =

CASE

WHEN @Input =...

phegedusich (9/7/2011)

---

Good!

I just read Steve' post today, because I didn't take the laptop to the cottage this weekend. It was the most relaxing Labor Day holiday I've had in a...

mtillman-921105 (9/7/2011)

---

Hmm, just noticed that SQL Server Central t-shirts are on sale here. 'A little pricey at $27.00 though, but I still may pick one up. I feel...

mtillman-921105 (9/7/2011)

---

Heh, I'm with you one this one Steve. We can't even automate loading a random flat file into a system.

Over a decade ago, I remember hoping...

Roy Ernest (9/6/2011)

---

Thanks Gus.

Yes, I live in a paradise. 🙂 White sandy beaches. No winter, No shark attacks yet..!!! 🙂

It is also famous for a place called Campo...

We are aware and whacking the account. Our apologies