|
|
Posted by Bartolo on 11/06/07 15:26
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...@greenms.com> wrote:
> "Bartolo" <andrew....@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]
|