you would probably need the latest MDAC update for the SQL driver

you could also run a repair of the .NET framework via add\remove programs

might i suggest if you have access to a virtualisation technology have a go at clustering on a couple of test servers before implementing. Virtual server Enterprise 2005 will happily...

generally consult your application vendor!

depends on the flavour of source and target sql server

the...

Hi

you can also do this by setting the database to offline, use the alter database modify file statement and then set back to online after.

this message is fairly descriptive!! The USE statement and exec must be separated by a semi colon like so

SELECT @execmd =...

also, SQL2005 is able to address as much RAM as the NOS will allow 😉

thats what i'm asking

that will be just fine, you'll need Enterprise edition of Windows server to address the extra RAM as...

Hi

i'm contracting at present, checkout Jobbserve and you'll see plenty of SQL opportunities both home and abroad

Steve

check with Esri but i'm sure changing the logical filenames will make no difference. The SDE database will be referenced by the database name only not by logical filename.

Grant Hoerz (9/11/2008)

---

This is a VBScript I've been running for a while. It takes each server name listed in a txt file, connects, dynamically grabs the drive info, and then...

why?

that's what i'm asking you 😉

hmm, i read that 64 bit SQL2005 standard doesnt support this and 64 bit sql2005 Ent requires it