Posted by Greg D. Moore \(Strider\) on 11/06/07 14:24

"Bartolo" <andrew.osa@gmail.com> wrote in message
news:1194353919.690014.304560@50g2000hsm.googlegroups.com...
> Hello Erland,
>
> Yes, I have directory and the file didn't exists and I tried
> removing .trc extension.

The directory exists on the server or on your client?

> 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
>
>



--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html

[Back to original message]