Actually, it seemed quite obvious to me and have never used the option personally.

Ratheesh.K.Nair (2/6/2009)

---

Thanks Lynn Pettis

Can you pleae tell how much is the normal CPU and memory utilisation of SQL Server if the RAM is 4GB.

(like it requires minimum of 30% CPU...

Venkat (2/6/2009)

---

Hi

I have two procedures

a) Procedure A

b) Procedure B

By design, Procedure B calls Procedure A internally. However, Two procedures can be executed independently .

I want to findout...

Ratheesh.K.Nair (2/6/2009)

---

Hi Experts,

I have SQL Server 2000 box with 4GB Ram. The system becomes slow in time and the memory and CPU utilization reaches values upto 2GB and 50% respectively....

Alvin Ramard (2/5/2009)

---

It is your experience why you will see me continue to try and help people even when it seems pointless to continue. It is those times where...

If this is a query run from a front-end process, you need to figure out how to run a trace from the PeopleSoft side. This is how we determined...

Bob Hovious (2/5/2009)

---

Just a note here that is sort of back on topic. I learned a lesson today that we benefit from being patient with others.

...

Okay, makes sense (1 and 2). Number 3, I haven't been told that, but I'm not trying to do that much with it and if I was, I'd just...

Paresh Prajapati (2/4/2009)

---

I got one new external IP from sql server errorlog..error like ''Login failed for user..client [external IP address].

I know that this is not our company internal IP..So, someone...

Why? You don't like working with PeopleSoft? 😉

But I thought this...

There is no transfer command. If you are archiving the data in other table, you have to insert it there, then delete it from the source table.

Actually, that is the best idea yet.

Go ahead, rub it in! 😛

Me either, and I have seen this type of code before. I think it is actually ORACLE.