There are articles at SSC regarding db ownership.

e.g. http://www.sqlservercentral.com/articles/Advanced/understandingobjectownership/1966/

We don't use sa for login, but have all databases owned by sa.

All sysadmin stuff is being performed using our windows-admin-accounts. (dbas...

You could offer the dba a weeping tissue because he's the one messing up. They will have to modify their code.

As already stated : If you want order, you need...

MS has released a Upgrade assistant for Access.

(free tool)

http://www.microsoft.com/sql/solutions/migration/access/default.mspx

Warren Peace (9/5/2008)

---

OK, I'm a litle stumped here. I have installed SQL 2005 on an Itanium build and I have set the RAM to use a boatload of ram 8192MB...

As usual, security has been optimized in sql2005 !

For a proc to work in a database context, it needs to be in that database,

except for procs (residing in master...

- How big is your transaction log file ?

- what's the growth size for the log file ?

- is...

Everything will still work, but will only use a single db-thread to accomplish the queries.

So it may need more time to complete, but your error will nolonger occur.

You may want...

Can you apply the workaround (i.e. disable parallelisme) ?

from KB319184

WORKAROUND

To work around this behavior you can either:

•Use the query hint (MAXDOP=1) to avoid a parallel query plan.

-or-

•Set the max degree...

Did you read and apply the hotfixes mentioned in KB918483 http://support.microsoft.com/kb/918483

are you using AWE ? http://support.microsoft.com/kb/899761

8.00.2039 is the regular SP4

Is this a multi processor or multi core box ?

if yes: IMO your should apply the cumulative hotfix I mentioned earlier.

Your extra software will need space, your extra databases will need space, your...

You didn't post the @@version.

This is a sqlserver parallelism issue.

Did you also apply Cumulative HofFix for sp4(build 2187) - SQL2000-KB916287-v8.00.2187 ?

Did you try DavidBs workaround ?

What were the results ?

may sound stupid, but would attaching a USB-drive (low cost high volume (up to 1 TB)) help out to make your local backup ?

Short term, very low cost.

And then...