AFAIK Analysis Service (32 bit) takes maximum 3Gb. Even if more is available.

did you disable AWE when you enabled the /3Gb switch ?

correct.

HTH

When you have 8Gb ram you should alter your boot.ini to use /3Gb _and_ /pae and _not_enable AWE ! 

This is what we have in the boot.ini :

multi(0)disk(0)rdisk(0)partition(1)\WINNT="Microsoft Windows 2000 Advanced Server...

John,

when you only have 4 Gb ram on your server AWE would be overhead because you should only use /3gb switch in the boot.ini

Have a look at http://www.sql-server-performance.com/awe_memory.asp

Sorry for the late followup : I've been attending SQLPASS2005

btw Natalia I got it working now

Thanks

just a thinking :

imgFname varchar(30),

that 30 may be to small, then you'll get an error stating truncation would take place if you want to store a imgFname that is...

arch the nice refs are gone, you must have edited the reply

I have one problem with an anymated gif, it appears to only...

I was trying to avoid just that

I'd seen you derive that info from " dRE.GetString(2) " and was hoping to find an equivalent...

you could offcourse use an alert in JobNumber1 final success step, wich launches JobNumber2, ... 

If this job-launching is depending on who/what launched the...

euh ... got a question

What if you have the image in a dataset

How can you figure...

SELECT

 ll.pid AS PID,

 la.oic AS OIC, 

 lo.NAME_1 AS NAME1,

 lo.NAME_2 AS NAME2, 

 lo.ADDRESS_1 AS ADD1, 

 la.set_id AS SET_ID,

 (la.gen_impr_net + la.gen_land_net) AS Assesment

FROM OWNERS lo INNER JOIN

 land_legal ll ON lo.EQUITY_ID = ll.legal_id

INNER...

thanks for the feedback

sorry for the fase ref.

try :

ALTER DATABASE [Dorian Event Archiver] Set single_user WITH ROLLBACK IMMEDIATE

go

You _will_ have to follow the procedure described in Allan Cui's article !