Phil Factor (1/31/2011)

---

A great deal of space in the internet is being taken up with he debate about climate change. It isn't really a database topic, and I don't think...

For a more step by step guide written by Gail :

Help, my database is corrupt. Now what?[/url]

djackson 22568 (1/31/2011)

---

RML51 (1/31/2011)

---

djackson 22568 (1/30/2011.....so called health care reform has reduced payments from goverment to hospitals, while increasing regulations and decreasing reimbursements from the one source they can use...

Slow moving here too... Why do you even need dynamic sql to run this procedure??

allin1 (1/31/2011)

---

Thanks steve , it makes sense.

One more question,What kind of problems/issues i have to face

If i leave my reporting environment in 2005 and move both Prod n...

Either one... won't matter.

why do you NOT want matching systems??

It usually causes way more problems than anything else.

Here's a question I ask myself when I feel like using hints :

Am I really smarter than the best MS engineer who had 10 000s of hours to think...

The convert needs to be executed first to do the comparaison. Hence it's impossible to use the convert for the validation because you have a no win situation.

Assuming you...

EricEyster (1/28/2011)

---

Ever go to an ATM that had a message "Down for system maintenance"? Maintenance windows were tollerated in the past when they were an accepted requirement of having computers....

We're in testing phase atm for SP4.

But since there was only like 5 bug fixes instead of 50, it's less worrysome... and yet I'm more on guard than ever!

1 way to confirm this is to compare both tables on the ids. See if they match perfectly (at least recently).

it would also do this if the transaction is rolled back by the calling proc or application.

Your trigger seems fine. so unless it's manually disabled on and off during...

carloarango@hotmail.com (1/25/2011)

---

For the past couple of weeks we have been seeing the temDB.mdf grow unexpectedly; it grows for 2 GB to 25 or 30 GB; I would hate to run...

I'd search the KB because I'm 99% sure that this bug has been fixed. I just can't tell you when it was.