I can see, and have had to make due, without LocalAdministrator on a SQL Server before. This is workable but a handicap.

But a DBA without sysadmin ??? No way !!!

I dunno ... errors from Macromedia and IIS ??? It sounds like something is amiss ...

Why don't the developers try reinstalling QA and a reboot.

Here is a sample script (adjust the sizes for your environment):

---

 use master

 go

---

 alter database tempdb modify file

  (name = tempdev,

  size = 8192MB,

  maxsize = 10241MB,

  filegrowth = 2048MB)

 go

 alter database tempdb modify file

  (name = templog,

  size...

Now another complete different thought ...

It might not make any difference at all depending on the size of your database and the number of rows of data in the tables being joined....

While I'll be ...

A 'common sense' decision made by management !

Is your company looking for DBA's ?

You could try to outline the time and money for efforts expended for keeping no databases other than the ones being tested on the QA server. Then it might be...

The old adage 'what changed last' may apply. However the soulution is relatively easy - I'd just reinstall EM !

I have never tried this approach. However I believe that it wil not work since the rollback process will have a some type of lock on the table. I believe...

Here is a link if you ever have some 'spare time' (yeah, right) if you ever want to go over a trillion ...

You may have a back door into the cluster is the SQL Server service and the cluster service are using domain user accounts, they have to be local admins,  and...

Here is one all important question, that depending on the answer, may go a long way towards explaining things. Since you are in a 'hosted' environment, is your SQL Server...

Many times I have seen applications and databases 'go down the tubes' performance-wise when adding or reaching a certain threshold of users. This is generally due to some limitation (bad...

Remember when there was: Initialization-Process-WrapUP

Then there was: Constructors-Instantiation-DeConstructors

Now there is: LaDeDa-LaDeDe-LaDeDo

BFD (I do not mean 'Big Furry Dog' either):

    Different shop window - another marketing pardigm

    Diffrent sales staff -...

The only assistance the command provide that I am aware of is the "-e errfile" option which is only useful on bcp "in" operations.

Slick ALZ ... very slick ... scanning the SQL errorlog tells all ... far better than read only or offline ...