How do I select all columns in the trace? Are you referring to all columns of all tables?

Robert Davis - the files are confidential. I will send you a PM. Thank you in advance for your help. 🙂

The server keeps going into single-user mode. Please help. :crying:

I opened the trace file in SQL Profiler and entered:

Search value: alter table

Data column: <All columns>

but it didn't return any results. Also the text data column is always...

Hi Robert,

The DB changed to single-user mode again, and I downloaded all the trace .trc files. How do I use these files to find out what caused the single-user...

The trace is running now ... how long should I run it for?

Hi Robert,

In the Events tab, under "Available Event Classes - TSQL", I selected "TSQL - SQL: StmtStartiing" and added it the "Selected event classes"

In the Filters tab, how to I...

Hopefully you can help ... please see three screenshots at http://bit.ly/1oCRgLh

Robert - SQL Profiler is freezing, and the firewall is asking if I should allow it to access the internet? Why does SQL Profiler need access to the internet?

I...

RE: You should run a SQL trace on the Object:Altered event to determine what is setting the database to single user.

Robert - I definitely need to figure out the problem...

Gail - CHECKDB found 0 allocation errors and 0 consistency errors.

Brad - The database isn't restored to another environment, but I also heard this could cause it to...

I've checked the error logs and the database goes into single-user mode either during or after a database backup or full index catalog rebuild.

I am guessing this is happening because...

There's no application that do this, and no one else has access to the database to run the command manually.

We use full text index and rebuild our catalog...

In Enterprise Manager, there are no maintenance plans set up.

I also returned no results for:

SELECT object_name(id)

FROM syscomments

WHERE text LIKE '%alter database%'

:unsure:

I don't think there are any maintenance plans. How do I check this, and also look for database integrity tasks ad see if "automatically repair minor problems" is checked?

How...