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.

arty 15255 (1/28/2011)

---

I had the same issue.

After some investigation I found that some temp tables (CREATE TABLE #...) are not dropped in some of my procedures.

After adding precisely everywhere...

All of them... always unless you have a specific reason not too like the 1 I mentionned earlier.

SP4 is available for SQL 2005 at this moment.

Makes no difference. You should always apply the latests patches to a new install. The only exception being on a dev machine where you need to match a...