AGREE

with the SQLGuru.

Auto update stats is not adequate.

There's a whole complicated selection algorithm for stats updating based on the rowcount and rowmodctr from sysindexes.

http://support.microsoft.com/kb/195565

It doesn't catch everything, that's for...

I think some of the information you want is in the default trace which is always running on SQL Server.

Not really sure because you were not all that descriptive in...

I know of very few DBAs who are not detail oriented.

Detail is part of the calling of the profession, and it calls each of us tightly wound, detail-oriented control freaks...

Are you talking about a SQL Trace?

you can select out of a trace by using this method:

http://www.sqlservercentral.com/Forums/Topic859816-146-1.aspx#bm859881

shew (2/4/2010)

---

SQLBOT,

This shows some nice possibilities for us. Apparently, something is auto-deleting the old files (and I am having them restored).

Do you know how to configure the auto-deletion so that...

That looks like a user-defined error message.

How are you being alerted of this message?

Maybe there's a monitoring script that has faulty logic in it.

query the default trace I think will get you that

SELECT *

FROM fn_trace_gettable('d:\drive\path\to\default\trace',1)

inner join sys.trace_events te on tr.eventclass = te.trace_event_id

WHERE category_id =...

Since your db2 is in standby it's going to be useless to you for anything.

You'll have to either use log shipping or replication to move that data to your secondary...

Mirrored SAN and HA clustering across sites would be a hardware solution.

For builtin solutions with SQL Server I would tend to think that log shipping would be the simplest.

Replication...

xp_cmdshell can be a safe and useful thing to turn on.

Don't create a proxy account and don't grant anyone into SA that shouldn't be.

wow... that was easy.

and the first...

If the wind ain't broke... don't fix it.

Nice article. I'm using synonyms like so many others.

It works better with SQL Compare.

post your max server memory settings from SQL and also post your available memory at the OS level.

Is SQL the only thing running on the machine?

Oh, and your allocated disk...

Pint

When you say no other users could get in do you mean they couldn't connect, or they were locked out of a table or DB and couldn't function?

It might help...

I didn't have an article, but the logical steps are:

secure IP addresses from networking

secure DNS cnames

assign IP's to NIC on SQL Server

test Cnames

use SQL Server configuration manager adn go to...