Posted by Bartolo on 11/06/07 12:58

Hello Erland,

Yes, I have directory and the file didn't exists and I tried
removing .trc extension. I thougt that it could be problem with
Profiler, because I had executed within it different trace and could
block directory. I stopped it, closed Profiler and still got Errorcode
12.
Do you have any other idea what would be the reason of this error?

Regards,
Bartolo

On 6 Lis, 12:57, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Bartolo (andrew....@gmail.com) writes:
> > I'm trying to execute server-side trace with SqlServer 2000 on
> > cluster. After scripting trace by Profiler I executed this script in
> > Queryanalyzer and got error code 12. According to BOL this code says
> > that file is not created but I don't know why, is there are any
> > obstacles which preventing to add this trace??
> > Does anybody had that problem?
>
> Does the directory exist? Does the file already exist? In the latter case,
> you need to deletet it first.
>
> > exec @rc = sp_trace_create @TraceID output, 0, N'C:\Profiler_result
> > \result.trc', @maxfilesize, NULL
>
> Also try removing ".trc". Trace adds that for you.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]