quote:

---

Yeah, buffer overrun or more probably memory leak!

---

you should apply the latest service pack from...

quote:

---

Stupdi me, figner troublle agin....

---

I assume the typos must have something...

quote:

---

Naming names eh! That's not fair. I would have responded anyway but out of the office for 43 weeks (as you know)...

quote:

---

select datename(month,1)

---

there is a little typo is the above

the second parameter specifies from which date...

Hi wildh,

quote:

---

As a general rule is there any performance gain in the order I list my tables in the FROM clause?

example table...

Well, after all, I'm not full time into SQL business. But that's something else!

I'm looking to fix this.

I guess, you call this a bum or lazybone. I spent my time...

quote:

---

Children do this to us, don't they?

---

Yes, pain can be so close to pleasure!

Frank

In addition to what Allen said, you might want to take a look at http://www.unixodbc.org or http://www.samba.org (which I would consider not that easy to implement)

Frank

quote:

---

It's not the first time that I read something about allowing columns to take NULL values not begin recommended.

To my point of...

Hi satishbt,

quote:

---

And I do agree with Frank, if this field is part of any of Composite PK or PK itself, or FK,...

quote:

---

Verified that the ID 7 does NOT exist in sysdatabases.

I have scripts for the sp and the job and have recreated them...

quote:

---

How can I update an "int" field and set it to NULL? What is the correct sql syntax?

---

September 8, 2003 at 4:47 am