Ratheesh.K.Nair (8/12/2008)

---

Thanks for the Reply,

...

You get '3456789'

Regards,

Andras

b_boy (8/11/2008)

---

The T_Items.AvailableLev <= 0 is the field within the table that informs end users of the available stock level “(back orders”- items where there is no stock available for...

Adam Zacks (8/11/2008)

---

when you change back to 'full' rec-mode from 'simple', should you then bakup the db and log (seperately) or just the db? I have only backed up the...

b_boy (8/11/2008)

---

These are the primary keys for the tables, and there are no constraints (sounds strange but thats they its set up)

T_OrderHeader - (PK, int, OrderID)

T_Payments -(PK, int, OrderID)

T_OrderLine...

rmaggio (8/11/2008)

---

Just curious if we can have just named instances, selecting one to be the default, or does one instance always have to be "unnamed" in the server environment? Not...

It would probably help us a lot if you could post the primary keys/unique constraints...

First suspects:

does a Stock_ID uniquely identify a single row in T_Items?

Are Payments belonging to a single order only?

- Regards,

Andras

Andras Belokosztolszki (8/11/2008)

And take a full backup after you have truncated the log and switched back to full recovery mode 🙂 Full recovery mode is not activated until a full...

Adam Zacks (8/11/2008)

---

Very business oriented Gail? Aggree with all though have found (rightly or wrongly that there is more then one way to skin a 't-log').

If you set yourself a...

bdh (8/11/2008)

---

Hi All

I am having a database, where we every night takes a full backup. The database has run for some time now and we have discovered that the log...

Hi Johan, while Chirag has answered your question, just a short note about the names you are using. If you want your code to be portable, do not capitalize system...

replace the 😉 with a ), and mt with the name of your table.

- Andras

SELECT Day

, SUM([Count])

FROM ( SELECT Sunday

...

Ratheesh.K.Nair (8/11/2008)

---

Hi Experts,

My problem is that i have a table containing 10 million records...