This job has worked in the past?

That would probably be nice. For now, everybody has to add that info to their sig.

Nice question. Thanks to DBCC Timewarp we were able to answer the Oct 14 question over a month early. :-D:-D:-D:-D

Thanks again Paul. Excellent explanation.

<> means "Not EQUAL"

Do you have the installation media for SQL Server (disc or iso file)?

You install these features from the installation media and select those particular options.

Typically reverse engineering is as simple as downloading the RDL and loading it up in BIDS. The RDL is made up of XML - so you could take it...

Install BIDS and the SQL Server Management tools.

This article explains that 32Bit dtexec will be installed in both 64 Bit and 32Bit

http://msdn.microsoft.com/en-us/library/ms162810(v=sql.90).aspx

jcrawf02 (9/7/2011)

---

SQLRNNR (9/7/2011)

---

jcrawf02 (9/7/2011)

---

SQLkiwi (9/7/2011)

---

mtillman-921105 (9/7/2011)

---

SQLkiwi (9/7/2011)

---

Stefan Krzywicki (9/7/2011)

---

Your birthday is 12/21? A good friend of mine has that same birthday. How do you feel about it being the shortest...

This should work for you.

SELECT o.DADMS_ID,

CASE WHEN o.Application=n.Application

THEN o.Application

ELSE 'Old: ' + o.Application + ' || New: ' + n.APPLICATION END

AS Application,

CASE WHEN o.Acronym=n.Acronym

THEN o.Acronym

ELSE 'Old:...

jcrawf02 (9/7/2011)

---

SQLkiwi (9/7/2011)

---

mtillman-921105 (9/7/2011)

---

SQLkiwi (9/7/2011)

---

Stefan Krzywicki (9/7/2011)

---

Your birthday is 12/21? A good friend of mine has that same birthday. How do you feel about it being the shortest day of...

Ninja's_RGR'us (9/7/2011)

---

piet.kouwer (9/7/2011)

---

Sound like a little sarcastic to me or am I wrong ?

I...

SQLkiwi (9/7/2011)

---

Talking of...

Stefan Krzywicki (9/7/2011)

---

SQLRNNR (9/7/2011)

---

Stefan Krzywicki (9/7/2011)

---

LutzM (9/7/2011)

---

SQLRNNR (9/7/2011)

---

Stefan Krzywicki (9/7/2011)

---

SQLRNNR (9/7/2011)

---

You...