Reconfiguring AWE worked and SQL Server is feeling much better.

Thank you all for your help!!!

I've seen the same behaviour from a Financial Application that I used to support in a previous job. The application would attempt to login to the database with the first...

I would be very discreet about setting up dml triggers for audit purposes. I've seen folks take this concept too far and end up impacting performance (due to the overhead)...

If the user isn't able to login, i don't believe it is a database permission problem (but more at an instance level). I would do the following

1. Ensure user is...

Yes, your SQL instance has AWE enabled.

As another verification you could go in to Perfmon and look for the Total Server Memory and Target Server Memory counters under SQL Server:...

Have you restarted SQL Server services?

After the restart, the most recent startup log should contain the words “Address Windowing Extensions enabled” early in the log.

It may be a long shot but do you have odbc tracing enabled on your machine. I've seen this impact EM (SQL 2000).

DotNet allows applications to be fail-over aware where if you have database mirroring setup you could put the names of the primary and secondary server in the connection string and...

I'm having this issue on Windows 2003 EE and SQL 2005 EE SP3

[boot loader]

timeout=5

default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /noexecute=optout /fastdetect /PAE

C:\CMDCONS\BOOTSECT.DAT="Microsoft Windows Recovery Console" /cmdcons

C through F drives RAID 10

Have...

That is correct, you will need read and write role membership to be able to read and write data and ddladmin role membership to be able to create / alter...

The 2 links provide conflicting information. I was under the impression it was Enterprise only, until I saw the features supported link which mentions automatic recovery from corruption for both...

Step 1. Patch Dev - backup databases, patch, have developers test

Step 2. Patch QA / Int - backup databases, patch, have testers test

Step 3. Patch Prod / DR - backup...

what do you mean share the agent service?

Do you have any partition schemes left over from the partitioning? If so, you won't be able to remove the filegroup unless you drop the schemes.

According to BOL

DBCC FREEPROCCACHE

"Removes all elements from the plan cache, removes a specific plan from the plan cache by specifying a plan handle or SQL handle, or removes all...