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_result
\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_setevent @TraceID, 10, 1, @on
/*here are n-setevents*/
exec sp_trace_setevent @TraceID, 43, 35, @on

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

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


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

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

error:
select ErrorCode=@rc

finish:
go


Thanks in advance for any advice
Regards,
Bartolo

Bartolo (andrew.osa (AT) gmail (DOT) com) writes:
Does the directory exist? Does the file already exist? In the latter case,
you need to deletet it first.

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

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

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... (AT) sommarskog (DOT) se> wrote:

"Bartolo" <andrew.osa (AT) gmail (DOT) com> wrote

The directory exists on the server or on your client?



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

Hello Greg,

Thanks for clue. Problem resloved. Yes, I know it's written within
script but I didn't know how it's working in order to cluster
environment.
-- Client side File and Table cannot be scripted
I don't connect to active node in my cluster during administrative
task jobs, most of them I manage from passive node.
So summarise, for executing server-side trace on cluster I must
connect to active node.

Regards
Bartolo


On 6 Lis, 15:24, "Greg D. Moore \(Strider\)"
<mooregr_deletet... (AT) greenms (DOT) com> wrote: