May 10, 2014 at 4:36 pm
1. Open the SQL Profiler tool
2. Connect to the server
3. Check Show All Events and Show All Columns
4. Deselect any pre-selected events
5. Expand Objects
6. Select Object:Altered event
7. Go back to the General tab
8. Check Save to File
9. Set the file path and name
10. Start the trace running
May 10, 2014 at 5:41 pm
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 have SQL Server 2000 and I can't get pass step 3. There isn't a "Show All Events and Show All Columns" area.
May 10, 2014 at 6:02 pm
SQL Profiler doesn't need access to the internet. It only needs access to the SQL Server. Your interface will be different from what I described. I haven't worked regularly with SQL 2000 in more than 10 years.
May 10, 2014 at 6:12 pm
Hopefully you can help ... please see three screenshots at http://bit.ly/1oCRgLh
May 10, 2014 at 9:26 pm
If there isn't an equivalent event to Object:Alter, you can do SQL:StmtCompleted and filter for an alter database statement.
May 12, 2014 at 12:28 pm
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 filter for an alter database statement? Please see screenshots at http://bit.ly/1oCRgLh
May 12, 2014 at 1:21 pm
The query text will be in the TextData column. So on the Filters tab, enter a filter of LIKE 'ALTER DATABASE' for the TextData column.
May 12, 2014 at 4:36 pm
The trace is running now ... how long should I run it for?
May 12, 2014 at 4:41 pm
Until the database is changed to single user again.
May 20, 2014 at 1:04 pm
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 problem again?
May 20, 2014 at 1:24 pm
Look at the commands (TextData column) and other relevant columns in the trace files using either the SQL Profiler tool or by querying the files directly with the built-in system function fn_trace_gettable().
May 20, 2014 at 4:19 pm
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 blank.
May 24, 2014 at 8:06 pm
The server keeps going into single-user mode. Please help. :crying:
May 24, 2014 at 9:49 pm
Can you post the trace files?
May 25, 2014 at 1:57 pm
Robert Davis - the files are confidential. I will send you a PM. Thank you in advance for your help. 🙂
Viewing 15 posts - 16 through 30 (of 32 total)
You must be logged in to reply to this topic. Login to reply