I'd suggest disabling the sa account

Log truncate job?

J (11/17/2008)

---

Gail,

I have always found your writings very interesting.

Regarding your solution, it is not immediately clear how your suggestion works in terms of being less susceptible to attack. Would...

How about

SELECT * FROM sysusers where name = 'sys'

On 2005, not easily. You can create an indexed view and put a unique clustered index on that, or you can define a calculated column and put the constraint on...

Maybe.

The database backup backed up data as it finds it on disk. Once it's done that, it backs up enough of the transaction log to ensure that the database can...

What wait type are you seeing on the queries when they run long?

The message is pretty self explanatory. SQL can't take a log backup...

Already have.

If you completely disable mirroring, you will have to restart it from scratch, with a restore of a full backup.

Why did you need to check the mirrored DB? It...

Why do you want to manage locking in the app?

SQL takes locks automatically in the required mode and with the best possible granularity for each statement, nad it will release...

I'm not sure I understand you. Have you stopped mirroring or are you planning to. First post said you had, second said you needed to do it. If you have...

Did you pause the mirroring session, or did you completely disable mirroring?

If you look at the servers in management studio's object explorer, do the database still mirrored and principal/mirror?

Someone tried to log into the SQL server and requested the database ASPState to be the default database. The ogin failed because the DB is inaccessible, or it doesn't exist

Reindex again with a higher fill factor. Do you have a reason for wanting the data pages to be only 40% full after the reindex?