you may want to read Jeff Modens "Tally table" article.

In sql2005 you can use ranking functions. Check BOL.

If you have heavy disk activity, it may be your extending tempdb-process that gets a timeout, resulting in the errormessage you've seen.

As already stated, tempdb is one of the working...

For the moment we are using vbscript to gather WMI information.

You may as well put that into a clr module and get your info that way.

Keep in mind you'll need...

X64 is not Itanium, but is 64 bit.

64-bit can directly address way more than 16Gb http://techreport.com/articles.x/8131/2 or http://en.wikipedia.org/wiki/X86-64

Thats why you don't need to enable AWE anymore on 64-bit.

You need to...

you could deny a user access to a table using:

DENY { ALL [ PRIVILEGES ] }

| permission [ ( column [ ,...n ] )...

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