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 |
|
joni
Yak Posting Veteran
50 Posts |
 Posted - 2006-09-29 : 13:26:59
|
| Hi Gurus,I need execute a Profiler with a command "isql". How can I do this?Any help is very well come.Thank´s in advanced.Joni |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-09-29 : 13:32:30
|
| Open up profiler, set up your trace, then select file->script trace->for sql 2000. Save that to a file, and feed it to isql. |
 |
|
|
joni
Yak Posting Veteran
50 Posts |
Posted - 2006-09-29 : 13:57:17
|
| Ok friend, but Can You send me the command line with de "isql".thank´s for your help,Joni |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-09-29 : 16:28:12
|
You can get all of the switches with isql /? For you, it will looks something likeisql -E -Sservername -i"profiler trace script file" This will generate trace files somewhere (you can modify the trace script to adjust just where). Did you really mean you have a trace file that you want to replay? |
|
|
|
EugeneZ
Starting Member
26 Posts |
Posted - 2006-09-29 : 21:05:42
|
| isql is ms-dos sql server utilitywhat is your goal?you can call from ms-dos profiler without isql:C:\>profiler.exe |
|
|
|
joni
Yak Posting Veteran
50 Posts |
Posted - 2006-10-02 : 09:06:23
|
| My goal is make a profiler execution under a job with programer execution time. For example execution every day at 10:00 AM until 11:00 AM. |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-10-02 : 10:15:12
|
| You would be better off using the script from Profiler as a SQL Agent job. All you would have to do is supply a filename (which the script asks for), and to set up the job. |
|
|
|
joni
Yak Posting Veteran
50 Posts |
Posted - 2006-10-02 : 11:42:07
|
| How can I do that? |
|
|
|
|
|
|
Profiler with isql