Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daimne
Starting Member
17 Posts |
 Posted - 2008-10-10 : 10:39:00
|
| We have 2000 server, and need to trace user logins to a file for a several months.what is the best way of doing this?i thought I could generate the script from profiler but does not look 2000 has this option or i'm missing something?TIA |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-10 : 12:34:32
|
| Hello,You can create trace template in SQL profiler GUI and go to file menu and save trace file as script. you can use this script to create server side profiler trace. You can specify filename and path to dump the data, also you can specify rollover size, to make reviewing the files efficient.Hope this helps. |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-10 : 12:40:40
|
| The best way is to create Server side trace with only tracing Login eventsor Alternatively, you can enable Successful and Failed logins in Server Properties but it will make Error log huge. |
|
|
|
daimne
Starting Member
17 Posts |
Posted - 2008-10-10 : 17:35:36
|
| Thanks! I tried this in 2000 but it allows to save template only in pdt format?any idea?TIA |
|
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-11 : 02:56:37
|
| SQL 2000 Profiler does allow you to script the trace.1. Start Profiler GUI, Go to File --> New --> trace.2. Connect to SQL Server.3. Select all needed Events in the "Trace Properties" Window.4. Click "Run", and then "Stop" the trace.5. Go to File --> Script Trace For..--> SQl Server 2000You can specify where you want to save the file. Once created you will need to edit the trace file to specify the location where trace file needs to be written. You can also change the roll over size.Hope this helps |
|
|
|
|
|
|
How to enable long time trace on MS SQL 2000 ?