The best way to handle that, if you really have no say over the table structure, would be to query the sys.columns table, using the object_id of the table you're...

I dug into this a bit more, and there's a flaw in the structure based on the logic.

It allows someone to pick donation ID 3 if they want America but...

There are detailed instructions online at MSDN.com for setting this up, and the pros and cons of doing so.

In my own experience, it was a major pain and other solutions...

If you turn on logging successful/failed logins, it will go in the log. Same one you get under the Management tab in SSMS. It's off by default because...

If you're inserting into a remote server, the DTC will kill the batch if it can't commit the transaction. That overrides Try...Catch functionality, per Books Online. I didn't...

michael.wiles (12/22/2009)

---

If quality is the only argument for a single source of applications, why can't there be a forum created specifically for rating, reviewing and ensuring quality of applications that...

Change it to rows, not collumns, as already suggested. It'll get nasty over time if you don't.

CirquedeSQLeil (12/22/2009)

---

How would that intro go?

Behold the Powerful semi,...

GilaMonster (12/22/2009)

---

Original, mostly. It's 3d graphics. Some of the models were purchased or...

Lynn Pettis (12/22/2009)

---

I'm starting to notice a trend in a few questions where people expect tables to store records in a specific order. Anyone else seeing that trend?

(Okay, two...

You could put the parts that might fail in a Try block, put error handling in the corresponding Catch block, and put the insert after that, probably in another Try...

Jedak (12/22/2009)

---

Toreador (12/22/2009)

---

"Due to the Holiday Season, and Frosty being a part of the season, an easy question was in order. "

It might be easy if you're American. Who's Frosty...

Relational tables don't have a first row or last row. The clustered index may, if there is one, but the table itself doesn't.

Why do you need to insert a...

Chanuka and Ramadan aren't date-coincident with Christmas, so the day...

I'm going to go with, "this is a job title they came up with on their own". You'll have to ask them what level of expertise they are looking...