sp_create_trace throws Errorcode = 12

[Bartolo]

Hi,

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?

If it helps I added script which I tried to execute:

-- Create a Queue
declare @rc int
declare @TraceID int
declare @maxfilesize bigint
set @maxfilesize = 5

exec @rc = sp_trace_create @TraceID output, 0, N'C:\Profiler_r esult
\result.trc', @maxfilesize, NULL
if (@rc != 0) goto error

-- Client side File and Table cannot be scripted

-- Set the events
declare @on bit
set @on = 1
exec sp_trace_seteve nt @TraceID, 10, 1, @on
/*here are n-setevents*/
exec sp_trace_seteve nt @TraceID, 43, 35, @on

-- Set the Filters
declare @intfilter int
declare @bigintfilter bigint

exec sp_trace_setfil ter @TraceID, 1, 1, 6, N'history'
exec sp_trace_setfil ter @TraceID, 1, 1, 6, N'move_history'
exec sp_trace_setfil ter @TraceID, 10, 0, 7, N'SQL Profiler'
exec sp_trace_setfil ter @TraceID, 35, 1, 6, N'kis'


-- Set the trace status to start
exec sp_trace_setsta tus @TraceID, 1

-- display trace id for future references
select TraceID=@TraceI D
goto finish

error:
select ErrorCode=@rc

finish:
go


Thanks in advance for any advice
Regards,
Bartolo

[Erland Sommarskog]

Re: sp_create_trace throws Errorcode = 12

Bartolo (andrew.osa@gma il.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_r esult
\result.trc', @maxfilesize, NULL

Also try removing ".trc". Trace adds that for you.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.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

[Bartolo]

Re: sp_create_trace throws Errorcode = 12

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...@sommars kog.sewrote:

Bartolo (andrew....@gma il.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_r esult
\result.trc', @maxfilesize, NULL

>
Also try removing ".trc". Trace adds that for you.
>
--
Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx

[Greg D. Moore \(Strider\)]

Re: sp_create_trace throws Errorcode = 12

"Bartolo" <andrew.osa@gma il.comwrote in message
news:1194353919 .690014.304560@ 50g2000hsm.goog legroups.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...@sommars kog.sewrote:

>Bartolo (andrew....@gma il.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_r esult
\result.trc', @maxfilesize, NULL

>>
>Also try removing ".trc". Trace adds that for you.
>>
>--
>Erland Sommarskog, SQL Server MVP, esq...@sommarsk og.se
>>
>Books Online for SQL Server 2005
>athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
>Books Online for SQL Server 2000
>athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx

>
>

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