how about trying :

alter database yourdb set online

long shot ... but ...

did someone try to run the "copy database" wizard

It does a detach...

since you dev-server is less strict than your prod server, there might be problems at dev-side.

on the other hand, if there were to occur problems, the developers would have to...

I don't know, but I can tell you this is not a one to one operation.

You'll need to think about your join predicates to determine which part(s) to use in...

check msmdsrv.exe in taskmanager.

IF pss says so, accept it.  For the moment I cannot check because I nolonger have msAs available on a big...

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...