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.

Try this: select right(convert(varchar(40), getdate(), 109), 14)

Jack Corbett (2/4/2009)

---

Try again. The DDL you posted is not for SQL Server as it uses the VARCHAR2 data type which does not exist in SQL Server. I...

I dropped the OP a PM. He hasn't read it or is ignoring it. Could also be a time difference as it could be early morning where he...

Trust me, our help they need not...

I've been trying to get our PeopleSoft Admin to take a look and offer some assistance too, but she's been a bit busy.