GilaMonster (1/15/2014)

---

I'm not a fan of dev and prod on the same server (mess up dev and you can take prod down), but don't move just on account of memory,...

I have my test & development environments on this VM too - so figure I'm better moving these to a new box and at least allowing the live environment to...

GilaMonster (1/15/2014)

---

Right, standard edition.

Standard is hard-capped at 2GB of memory. It can't use more so the other 4GB of memory you have on that server is wasted. So the 1.6GB...

GilaMonster (1/15/2014)

---

Probably means SQL doesn't need more. If you're not running load on it, it won't use more memory than it needs.

That said, that looks like 32-bit without AWE or...

Thanks for the notes above!

D

Hi,

for total server memory (KB) I am getting the following

Last: 1671008

Average: 1670883

Minimum: 1670856

Maximum: 1671648

I was hoping that at...

Will reboot with this setting off and report back.

Will do Gail, would you mind explaining this?

Not being argumentative just wanting/trying to understand

Dave

Thanks man, will see what I can find in performance monitor!

That's it, oh god that was so obvious now

Thanks so much Chris

In fact if I strip it down even further I still get issues

Server: Msg 170, Level 15, State 1, Procedure STP_Agent_upload, Line 38

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 38: Incorrect syntax...

Thanks Chris!

Oh good god, not sure how I couldn't see that... Well sleep deprivation I guess

I have changed the code to the below but still get an error -...

ChrisM@Work (3/6/2013)

---

Plateau (3/6/2013)

---

Hi Chris,

I have temporarily changed it to a varchar - in the input parameters bit however...

Hi Chris,

I have temporarily changed it to a varchar - in the input parameters bit however I still...

CREATE PROCEDURE [dbo].[STP_Agent_upload]

(

-- List Input Parameters

@Agent_Number VARCHAR(50), --column A

@Date_Last_Payment DATETIME, --column C

@policy_number VARCHAR (50), --column D

@Agent_Payment_Amount SMALLMONEY, -- [Net] -> this is column M

@Row_Number VARCHAR (100), --PASS this from application!

@Return_Message VARCHAR (255) OUTPUT

)

AS BEGIN

--List...