Posted by Erland Sommarskog on 11/06/07 11:57

Bartolo (andrew.osa@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Shortcut For QA
• Prev in forum: SQL Enterprise Manager on Windows Vista
• Thread view: Re: sp_create_trace throws Errorcode = 12

[Reply to this message]