Thanks so much guys.

The problem was what alzdba suggested. The user was granted System Admin role and hence needed to be qualifyed. After I remove the role privilege, all seem...

Thanks John. Makes the concept of AWE little bit more clear.

Partitioning is another option that I am looking into. Any links to some helpful notes please.

Is the SQL Server service started with a domain user account?

I have had this issue if my service is started with the local system account.

Regards.

Thanks Greg for the reply. I shall find out if they are offering the course in the near future.

Brain, I am having to support only SQL Server and not the...

Unfortunately, in BOL "user accounts, changing" only shows howto change a user account to service. Eventually I may have to write a procedure to select pid and logon time and...

Hi Steve,

Thanks for the quick response. However, there is still one query.

I just went to the registration site and had entered the SSC promo code. But the price quoted was same...