dear sir/madam
  When I open enterprse manager and wants to change some record and
try to save then it gives a messaage
Transaction can not start while in firehose mode.

We have some performance issues on our db server memory on the box is 32GB. I
am looking out for perfmon counters what is the value should for both memory
grants pending/memory grants outstanding?
Memory grants pending the value seems to be 0 for this counter

We have a database where no PK constraints are defined and only unique
clustered indexes.  Is there a way for us to change all the columns that make
up the unique clustered index in all of the tables in the database to be the
columns that make up the PK constraint of the tables?  ...

In the EM, when selecting a few databases I receive an error dialog offering
to debug.
Error Runtime, Line 306, Unspecified
Canceling shows the taskpad view w/out any info.