Jack Corbett (7/29/2008)

---

I assume this will work on a server as it works on my PC. Right-Click on My Computer -> Properties and on mine it says Intel Core...

alimcitp (7/29/2008)

---

Thanks for your suggestions but this is not me who written the script this is written by some one else in the company and that is why its really...

It depends on the error. I looked at the GIF, and some of the data is cut off at the right, but it looks like it either an error...

Have you run a trace (from Profiler or your own) to find what that SPID is doing when it starts eating up all the RAM?

Is it possible that there's an...

The problem with the script is that it was written by someone who doesn't understand flow control, doesn't understand the scope-limitations of dynamic SQL and doesn't understand code sequentiality.

I see...

Atif, yeah, I bet you're right! I should have seen that as well. He's got the variable being assigned as the return value from the proc, which is...

Have you taken a look at index/table fragmentation and at how current the statistics are?

Hard drives are cheap. Get IT/SA to add some space to the dev system.

Actually, it does make sense. xp_cmdshell can only take one set of double-quotes, per Books Online, and then it just ignores the ones after that. The first two...

Yep.

My car gets about 19 mpg, but I drive so little that I've had to fill the tank (from the halfway mark) three times in the last year. So,...

tvu4251 (7/10/2008)

---

in Houston, only people with death wish are bikers. There are very few bike lanes, and mostly for recreation only, meaning in parks and such places. Have anyone try...

Just to increase the pain: My commute is just about 1 mile. When the weather is nice, I walk.

The key thing is pick a good primary key and a good clustered index (not necessarily the same thing, but might be). Keep in mind that check constraints can...

If/when my job and skills become obsolete, I'll learn something new. I have never understood people who demand that automating their job not be done, because they prefer doing...