Valid. However, this wasn't a question about table design and instead the table exists solely to make the point about the fact that...

Hugo Kornelis (10/24/2011)

---

Either the question's author was not aware of the simpler methods (in which case this question was a learning experience for everyone), or he was deliberately trying to...

SQLRNNR (10/11/2011)

---

I find that this could prove very helpful. Microsoft has a tool available to help convert too - name and location of the download escape me right now...

We have an application we're going to look at migrating from Oracle to MSSQL so I'm going to file this article away to help with changing the code. Thanks...

s_osborne2 (10/7/2011)

---

This should do that for you. Needs some refinement, but you get the gist...

-- Gets the SQL Text from the transaction id

SELECT text,*

FROM

sys.dm_tran_active_transactions tat

JOIN sys.dm_exec_requests er

ON er.transaction_id = tat.transaction_id

CROSS...

sys.dm_tran_active_transactions will. I'm not aware of a way to get the statement from that but by looking at the sys.dm_tran_loks...

One option, albeit a very, very expensive one, is to see if you can send the disks off to a data recovery company to see if the original bits can...

I'm not sure if this will come into play where I work but it's definitely worth knowing in case it does. Thanks for the question.

SQL handles the fact that the first column is an identity and identity insert isn't on so it ignores the first column because it knows it's generating that data.

That may not be a bad...

It's been good getting some of these harder questions that require knowing how SQL works. Thanks for taking the time to put them together.

Revenant (9/7/2011)

---

cfradenburg (9/7/2011)

---

majorbloodnock (9/7/2011)

---

What is less believable is the automation of contract negotiation; the question of "do I want to do business with this company?" can hinge on all sorts...

majorbloodnock (9/7/2011)[hrWhat is less believable is the automation of contract negotiation; the question of "do I want to do business with this company?" can hinge on all sorts of intangible...

Really good question. Even though I had run into both of these I still had to think. If 1,3 and 4 failing had been an option that would...

Since I'm sure there are a number of people from other countries that don't have any interest in his...