Oh btw, this is only 1 of the queries part of a 6000 lines code snippet, under a single button click.

They claim this program runs slow (25 minutes to generate...

5$ says you might not be able to find everything wrong with it in 1 scan!!!

Thanks Gail.

I'll have to close this one with we're going to upgrade to 2008 standard as soon as possible since we'll be forced to at some point. ...

GilaMonster (10/16/2009)

---

Ninja's_RGR'us (10/15/2009)

---

GilaMonster (10/15/2009)

---

Can you find/get vendor to find...

Matt Miller (#4) (10/15/2009)

---

was his laptop 64-bit by any chance? Because that would allow him to use twice as much RAM for SQL (since SQL could use 4, and...

I...

Elliott W (10/15/2009)

---

Depending on the size of your database memory could be a hangup.. But other than the processor, memory, and database size limits Express and Standard a virtually...

GilaMonster (10/15/2009)

---

Can you find/get vendor to find the wait...

Thanks guys, I knew I could count on you.

After posting the thread I did a little more digging and apparently hardware limits may be a problem. The DB is...

Snow, today????

It's almost 80 here, in CANADA.

barb.wendling (4/12/2009)

---

http://msdn.microsoft.com/en-us/library/aa933268(SQL.80).aspx

BOL states:

When true, users can only read data in the database. Users cannot modify the data or database objects, however, the database itself can be deleted using the DROP...

Maybe using DAC to connect or having the whole server in single user... but then what's the point of setting master to read_only??

It's a bit hard to believe that 67% of the people are wrong about this ;).

I agree, but I only ran this against 2005 instance (no access to 2000).

makes more sens to not have it read only in the first place.

On 2008 it's definitly not...

I would just start small.

First make sure you can do a select on the oracle box from the sql server box (will required a linked server or openrowset / openquery).

Then...