nope- no where clause. Just "select top 1 * from table"... that's it.

Thanks for the info guys- I don't know yet why they are doing "select top 1 * from table"... waiting for that info back from the app admin. I...

Did you ever figure it out? I have it going on right now also and am working to get hosting to remove the defrag utility (which I know has...

Looks good to me.

Why not increase the number of logs... that way you can still keep them the desired amount of time, but cycle frequently.

As far as I have seen the only deteriment...

I will bet $$ that this server is running diskkeeper.

Confirm network connectivity to the mail server- i.e. can you telnet to it over port 25 (telnet servername 25).

Try using fully qualified server name... error message shows "error connecting to server\instance".

Change connection to look for servername.domain.com\instance

(of course by domain.com, I mean whatever the fully qualified name of...

How about posting that error message?

first thought is that this is probably network related. Can you telnet to the sqlserver over port 1433... i.e. if you execute the following...

Just to clarify- I'm talking about the configuration in "services.msc". Post above mine is right on- all this configuration should be done in Cluster Administrator. Don't make changes...

The SQL Server Service and Agent Service should NOT be set to automatic- if so, on startup, those services will attempt to start on both nodes.

The Cluster Service should be...

YOU DONT HAVE TO YELL.. nah, just kidding.

I don't understand what you mean by "when I change and save it it goes back"...

Once you delete records, you...

If your concern is recoverability, full backups 2Xs daily might not be the best solution.

Why not operate in full recovery mode- you could do a full backup daily and then...

I can't tell you why the table take so much space- what is in it? How is the table defined (what datatypes are the columns)?

The datafile will not automatically...

Looks like 1 table using most of the space:

dbo.EventLog U 561681 5726.102 - 994.203 == 4731.898 = 56.813 + 4675.086

almost 6GB there

Performance issues... no, this is just a select. ...