RBarryYoung (8/18/2009)

---

Lynn Pettis (8/18/2009)

---

RBarryYoung (8/18/2009)

---

Grrr. Another person who seems to think that I should be doing their work for them. ... :angry: My back really hurts right now...

RBarryYoung (8/18/2009)

---

Grrr. Another person who seems to think that I should be doing their work for them. ... :angry: My back really hurts right now and I fear...

What is needed is the DDL for the tables (or a least enough of it to work on the query), sample data for the tables (fake data is fine as...

Not sure, but this is looking more like FIFO Inventory problem than an Aging problem.

From looking at the sample data in the spreadsheet, you are deduction the (-n) from the...

harry.sh16 (8/17/2009)

---

My Destination column data type cannot be changed it has to remain numeric but i can make it to numeric(2,0) or numeric (3,0) depending on the source which has...

Here is what I think. Even if you could, should you? This is one of those things that I think should be left alone. There is a...

I have to agree with...

rjv_rnjn (8/17/2009)

---

GSquared (8/17/2009)

---

While this was beginning to feel like the credits for Monty Python's Quest for the Holy Grail ("those responsible for sacking the people responsible for the credits have...

Just...

To be honest, I think I'm underpaid. I work hard, get things done. I don't have any MS Certififications, though I'd like to get the SQL Server certs,...

Using the schema name in a query is preferred. It helps the system determine what table/view/procedure/etc is being accessed or executed without having to go through default schemas and...

jamie (8/17/2009)

---

it's supposed to be UTC time (by design) I believe for consistency between servers in different timezones, etc. So I'd check the timezone on your server to start....

ta.bu.shi.da.yu (8/17/2009)

---

I'm curious as to what would be seen as a dumb question that is acceptable, and a dumb question that isn't acceptable?

Obviously, the question I saw earlier (how do...

Based on the error message, I'd say you have a user accessing the database. You may want to run an SP_WHO2 and see who is using the database.

rambilla4 (8/16/2009)

---

Hi,

I have configured Log shipping in Sql server 2005. I'm confused with date format that the transaction log backups showing. The transaction log backup ran through the backup jobs...